﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FHFPDataSet" targetNamespace="http://tempuri.org/FHFPDataSet.xsd" xmlns:mstns="http://tempuri.org/FHFPDataSet.xsd" xmlns="http://tempuri.org/FHFPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FHFPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FHFPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.testForReports.Properties.Settings.GlobalReference.Default.FHFPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAppointmentsTableAdapter" GeneratorDataComponentClassName="tblAppointmentsTableAdapter" Name="tblAppointments" UserDataComponentName="tblAppointmentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblAppointments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblAppointments] WHERE (([PKappointmentID] = @Original_PKappointmentID) AND ([name] = @Original_name) AND ([startTime] = @Original_startTime) AND ([endTime] = @Original_endTime) AND ([date] = @Original_date) AND ([desciption] = @Original_desciption))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKappointmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKappointmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_startTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="startTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_endTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="endTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_desciption" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="desciption" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblAppointments] ([name], [startTime], [endTime], [date], [desciption]) VALUES (@name, @startTime, @endTime, @date, @desciption);
SELECT PKappointmentID, name, startTime, endTime, date, desciption FROM tblAppointments WHERE (PKappointmentID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@startTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="startTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@endTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="endTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@desciption" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="desciption" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKappointmentID, name, startTime, endTime, date, desciption FROM dbo.tblAppointments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblAppointments] SET [name] = @name, [startTime] = @startTime, [endTime] = @endTime, [date] = @date, [desciption] = @desciption WHERE (([PKappointmentID] = @Original_PKappointmentID) AND ([name] = @Original_name) AND ([startTime] = @Original_startTime) AND ([endTime] = @Original_endTime) AND ([date] = @Original_date) AND ([desciption] = @Original_desciption));
SELECT PKappointmentID, name, startTime, endTime, date, desciption FROM tblAppointments WHERE (PKappointmentID = @PKappointmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@startTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="startTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@endTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="endTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@desciption" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="desciption" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKappointmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKappointmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_startTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="startTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_endTime" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="endTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_desciption" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="desciption" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKappointmentID" ColumnName="PKappointmentID" DataSourceName="FHFP.dbo.tblAppointments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKappointmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKappointmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKappointmentID" DataSetColumn="PKappointmentID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="startTime" DataSetColumn="startTime" />
              <Mapping SourceColumn="endTime" DataSetColumn="endTime" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="desciption" DataSetColumn="desciption" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblBillAccountTableAdapter" GeneratorDataComponentClassName="tblBillAccountTableAdapter" Name="tblBillAccount" UserDataComponentName="tblBillAccountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblBillAccount" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblBillAccount] WHERE (([PKbillAccountID] = @Original_PKbillAccountID) AND ([FKBillID] = @Original_FKBillID) AND ([accountNum] = @Original_accountNum) AND ([phoneNum] = @Original_phoneNum) AND ((@IsNull_website = 1 AND [website] IS NULL) OR ([website] = @Original_website)) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbillAccountID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbillAccountID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKBillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKBillID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_accountNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accountNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="website" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="website" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblBillAccount] ([FKBillID], [accountNum], [phoneNum], [website], [login], [password]) VALUES (@FKBillID, @accountNum, @phoneNum, @website, @login, @password);
SELECT PKbillAccountID, FKBillID, accountNum, phoneNum, website, login, password FROM tblBillAccount WHERE (PKbillAccountID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKBillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKBillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@accountNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accountNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="website" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKbillAccountID, FKBillID, accountNum, phoneNum, website, login, password FROM dbo.tblBillAccount</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblBillAccount] SET [FKBillID] = @FKBillID, [accountNum] = @accountNum, [phoneNum] = @phoneNum, [website] = @website, [login] = @login, [password] = @password WHERE (([PKbillAccountID] = @Original_PKbillAccountID) AND ([FKBillID] = @Original_FKBillID) AND ([accountNum] = @Original_accountNum) AND ([phoneNum] = @Original_phoneNum) AND ((@IsNull_website = 1 AND [website] IS NULL) OR ([website] = @Original_website)) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)));
SELECT PKbillAccountID, FKBillID, accountNum, phoneNum, website, login, password FROM tblBillAccount WHERE (PKbillAccountID = @PKbillAccountID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKBillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKBillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@accountNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accountNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="website" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbillAccountID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbillAccountID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKBillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKBillID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_accountNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accountNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="website" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_website" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="website" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKbillAccountID" ColumnName="PKbillAccountID" DataSourceName="FHFP.dbo.tblBillAccount" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKbillAccountID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKbillAccountID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKbillAccountID" DataSetColumn="PKbillAccountID" />
              <Mapping SourceColumn="FKBillID" DataSetColumn="FKBillID" />
              <Mapping SourceColumn="accountNum" DataSetColumn="accountNum" />
              <Mapping SourceColumn="phoneNum" DataSetColumn="phoneNum" />
              <Mapping SourceColumn="website" DataSetColumn="website" />
              <Mapping SourceColumn="login" DataSetColumn="login" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblBillResponsibleTableAdapter" GeneratorDataComponentClassName="tblBillResponsibleTableAdapter" Name="tblBillResponsible" UserDataComponentName="tblBillResponsibleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblBillResponsible" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblBillResponsible] WHERE (([PKbillRespID] = @Original_PKbillRespID) AND ([FKmemberID] = @Original_FKmemberID) AND ([FKbillID] = @Original_FKbillID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbillRespID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbillRespID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKbillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbillID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblBillResponsible] ([FKmemberID], [FKbillID]) VALUES (@FKmemberID, @FKbillID);
SELECT PKbillRespID, FKmemberID, FKbillID FROM tblBillResponsible WHERE (PKbillRespID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKbillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKbillRespID, FKmemberID, FKbillID FROM dbo.tblBillResponsible</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblBillResponsible] SET [FKmemberID] = @FKmemberID, [FKbillID] = @FKbillID WHERE (([PKbillRespID] = @Original_PKbillRespID) AND ([FKmemberID] = @Original_FKmemberID) AND ([FKbillID] = @Original_FKbillID));
SELECT PKbillRespID, FKmemberID, FKbillID FROM tblBillResponsible WHERE (PKbillRespID = @PKbillRespID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKbillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbillRespID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbillRespID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKbillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbillID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKbillRespID" ColumnName="PKbillRespID" DataSourceName="FHFP.dbo.tblBillResponsible" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKbillRespID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKbillRespID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKbillRespID" DataSetColumn="PKbillRespID" />
              <Mapping SourceColumn="FKmemberID" DataSetColumn="FKmemberID" />
              <Mapping SourceColumn="FKbillID" DataSetColumn="FKbillID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblBillsTableAdapter" GeneratorDataComponentClassName="tblBillsTableAdapter" Name="tblBills" UserDataComponentName="tblBillsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblBills" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblBills] WHERE (([PKbillID] = @Original_PKbillID) AND ([FKcompanyID] = @Original_FKcompanyID) AND ([billName] = @Original_billName) AND ([totalAmountDue] = @Original_totalAmountDue) AND ((@IsNull_eachMemberAmount = 1 AND [eachMemberAmount] IS NULL) OR ([eachMemberAmount] = @Original_eachMemberAmount)) AND ([dateDue] = @Original_dateDue) AND ([dateLastPaid] = @Original_dateLastPaid) AND ([dateAdded] = @Original_dateAdded) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ([paidAmount] = @Original_paidAmount))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbillID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_billName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="billName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_totalAmountDue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountDue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_eachMemberAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="eachMemberAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_eachMemberAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="eachMemberAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateDue" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateDue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastPaid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_paidAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="paidAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblBills] ([FKcompanyID], [billName], [totalAmountDue], [eachMemberAmount], [dateDue], [dateLastPaid], [dateAdded], [description], [paidAmount]) VALUES (@FKcompanyID, @billName, @totalAmountDue, @eachMemberAmount, @dateDue, @dateLastPaid, @dateAdded, @description, @paidAmount);
SELECT PKbillID, FKcompanyID, billName, totalAmountDue, eachMemberAmount, dateDue, dateLastPaid, dateAdded, description, paidAmount FROM tblBills WHERE (PKbillID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@billName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="billName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@totalAmountDue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountDue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@eachMemberAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="eachMemberAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateDue" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateDue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastPaid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@paidAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="paidAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKbillID, FKcompanyID, billName, totalAmountDue, eachMemberAmount, dateDue, dateLastPaid, dateAdded, description, paidAmount FROM dbo.tblBills</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblBills] SET [FKcompanyID] = @FKcompanyID, [billName] = @billName, [totalAmountDue] = @totalAmountDue, [eachMemberAmount] = @eachMemberAmount, [dateDue] = @dateDue, [dateLastPaid] = @dateLastPaid, [dateAdded] = @dateAdded, [description] = @description, [paidAmount] = @paidAmount WHERE (([PKbillID] = @Original_PKbillID) AND ([FKcompanyID] = @Original_FKcompanyID) AND ([billName] = @Original_billName) AND ([totalAmountDue] = @Original_totalAmountDue) AND ((@IsNull_eachMemberAmount = 1 AND [eachMemberAmount] IS NULL) OR ([eachMemberAmount] = @Original_eachMemberAmount)) AND ([dateDue] = @Original_dateDue) AND ([dateLastPaid] = @Original_dateLastPaid) AND ([dateAdded] = @Original_dateAdded) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ([paidAmount] = @Original_paidAmount));
SELECT PKbillID, FKcompanyID, billName, totalAmountDue, eachMemberAmount, dateDue, dateLastPaid, dateAdded, description, paidAmount FROM tblBills WHERE (PKbillID = @PKbillID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@billName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="billName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@totalAmountDue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountDue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@eachMemberAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="eachMemberAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateDue" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateDue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastPaid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@paidAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="paidAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbillID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbillID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_billName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="billName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_totalAmountDue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountDue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_eachMemberAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="eachMemberAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_eachMemberAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="eachMemberAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateDue" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateDue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastPaid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_paidAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="paidAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKbillID" ColumnName="PKbillID" DataSourceName="FHFP.dbo.tblBills" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKbillID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKbillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKbillID" DataSetColumn="PKbillID" />
              <Mapping SourceColumn="FKcompanyID" DataSetColumn="FKcompanyID" />
              <Mapping SourceColumn="billName" DataSetColumn="billName" />
              <Mapping SourceColumn="totalAmountDue" DataSetColumn="totalAmountDue" />
              <Mapping SourceColumn="eachMemberAmount" DataSetColumn="eachMemberAmount" />
              <Mapping SourceColumn="dateDue" DataSetColumn="dateDue" />
              <Mapping SourceColumn="dateLastPaid" DataSetColumn="dateLastPaid" />
              <Mapping SourceColumn="dateAdded" DataSetColumn="dateAdded" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="paidAmount" DataSetColumn="paidAmount" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblBrandLUTableAdapter" GeneratorDataComponentClassName="tblBrandLUTableAdapter" Name="tblBrandLU" UserDataComponentName="tblBrandLUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblBrandLU" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblBrandLU] WHERE (([PKbrandID] = @Original_PKbrandID) AND ([brandName] = @Original_brandName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbrandID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_brandName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="brandName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblBrandLU] ([brandName]) VALUES (@brandName);
SELECT PKbrandID, brandName FROM tblBrandLU WHERE (PKbrandID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@brandName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="brandName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKbrandID, brandName FROM dbo.tblBrandLU</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblBrandLU] SET [brandName] = @brandName WHERE (([PKbrandID] = @Original_PKbrandID) AND ([brandName] = @Original_brandName));
SELECT PKbrandID, brandName FROM tblBrandLU WHERE (PKbrandID = @PKbrandID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@brandName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="brandName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKbrandID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_brandName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="brandName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKbrandID" ColumnName="PKbrandID" DataSourceName="FHFP.dbo.tblBrandLU" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKbrandID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKbrandID" DataSetColumn="PKbrandID" />
              <Mapping SourceColumn="brandName" DataSetColumn="brandName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCompanyTableAdapter" GeneratorDataComponentClassName="tblCompanyTableAdapter" Name="tblCompany" UserDataComponentName="tblCompanyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblCompany" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCompany] WHERE (([PKcompanyID] = @Original_PKcompanyID) AND ([FKcompTypeID] = @Original_FKcompTypeID) AND ([name] = @Original_name) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ([city] = @Original_city) AND ([state] = @Original_state) AND ([zip] = @Original_zip) AND ((@IsNull_phoneNum = 1 AND [phoneNum] IS NULL) OR ([phoneNum] = @Original_phoneNum)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKcompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phoneNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCompany] ([FKcompTypeID], [name], [address], [city], [state], [zip], [phoneNum]) VALUES (@FKcompTypeID, @name, @address, @city, @state, @zip, @phoneNum);
SELECT PKcompanyID, FKcompTypeID, name, address, city, state, zip, phoneNum FROM tblCompany WHERE (PKcompanyID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKcompanyID, FKcompTypeID, name, address, city, state, zip, phoneNum FROM dbo.tblCompany</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCompany] SET [FKcompTypeID] = @FKcompTypeID, [name] = @name, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [phoneNum] = @phoneNum WHERE (([PKcompanyID] = @Original_PKcompanyID) AND ([FKcompTypeID] = @Original_FKcompTypeID) AND ([name] = @Original_name) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ([city] = @Original_city) AND ([state] = @Original_state) AND ([zip] = @Original_zip) AND ((@IsNull_phoneNum = 1 AND [phoneNum] IS NULL) OR ([phoneNum] = @Original_phoneNum)));
SELECT PKcompanyID, FKcompTypeID, name, address, city, state, zip, phoneNum FROM tblCompany WHERE (PKcompanyID = @PKcompanyID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKcompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phoneNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_phoneNum" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKcompanyID" ColumnName="PKcompanyID" DataSourceName="FHFP.dbo.tblCompany" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKcompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKcompanyID" DataSetColumn="PKcompanyID" />
              <Mapping SourceColumn="FKcompTypeID" DataSetColumn="FKcompTypeID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="state" DataSetColumn="state" />
              <Mapping SourceColumn="zip" DataSetColumn="zip" />
              <Mapping SourceColumn="phoneNum" DataSetColumn="phoneNum" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCompTypeLUTableAdapter" GeneratorDataComponentClassName="tblCompTypeLUTableAdapter" Name="tblCompTypeLU" UserDataComponentName="tblCompTypeLUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblCompTypeLU" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCompTypeLU] WHERE (([PKcompTypeID] = @Original_PKcompTypeID) AND ([compType] = @Original_compType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_compType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="compType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCompTypeLU] ([compType]) VALUES (@compType);
SELECT PKcompTypeID, compType FROM tblCompTypeLU WHERE (PKcompTypeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@compType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="compType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKcompTypeID, compType FROM dbo.tblCompTypeLU</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCompTypeLU] SET [compType] = @compType WHERE (([PKcompTypeID] = @Original_PKcompTypeID) AND ([compType] = @Original_compType));
SELECT PKcompTypeID, compType FROM tblCompTypeLU WHERE (PKcompTypeID = @PKcompTypeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@compType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="compType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_compType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="compType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKcompTypeID" ColumnName="PKcompTypeID" DataSourceName="FHFP.dbo.tblCompTypeLU" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKcompTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKcompTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKcompTypeID" DataSetColumn="PKcompTypeID" />
              <Mapping SourceColumn="compType" DataSetColumn="compType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblExpenseTableAdapter" GeneratorDataComponentClassName="tblExpenseTableAdapter" Name="tblExpense" UserDataComponentName="tblExpenseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblExpense" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblExpense] WHERE (([PKexpenseID] = @Original_PKexpenseID) AND ([FKtenderTypeID] = @Original_FKtenderTypeID) AND ([FKmemberID] = @Original_FKmemberID) AND ((@IsNull_datePurch = 1 AND [datePurch] IS NULL) OR ([datePurch] = @Original_datePurch)) AND ([totalAmountPaid] = @Original_totalAmountPaid) AND ([type] = @Original_type) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKexpenseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_datePurch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="datePurch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_datePurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePurch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_totalAmountPaid" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblExpense] ([FKtenderTypeID], [FKmemberID], [datePurch], [totalAmountPaid], [type], [description]) VALUES (@FKtenderTypeID, @FKmemberID, @datePurch, @totalAmountPaid, @type, @description);
SELECT PKexpenseID, FKtenderTypeID, FKmemberID, datePurch, totalAmountPaid, type, description FROM tblExpense WHERE (PKexpenseID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@datePurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePurch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@totalAmountPaid" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKexpenseID, FKtenderTypeID, FKmemberID, datePurch, totalAmountPaid, type, description FROM dbo.tblExpense</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblExpense] SET [FKtenderTypeID] = @FKtenderTypeID, [FKmemberID] = @FKmemberID, [datePurch] = @datePurch, [totalAmountPaid] = @totalAmountPaid, [type] = @type, [description] = @description WHERE (([PKexpenseID] = @Original_PKexpenseID) AND ([FKtenderTypeID] = @Original_FKtenderTypeID) AND ([FKmemberID] = @Original_FKmemberID) AND ((@IsNull_datePurch = 1 AND [datePurch] IS NULL) OR ([datePurch] = @Original_datePurch)) AND ([totalAmountPaid] = @Original_totalAmountPaid) AND ([type] = @Original_type) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)));
SELECT PKexpenseID, FKtenderTypeID, FKmemberID, datePurch, totalAmountPaid, type, description FROM tblExpense WHERE (PKexpenseID = @PKexpenseID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@datePurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePurch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@totalAmountPaid" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKexpenseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_datePurch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="datePurch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_datePurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePurch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_totalAmountPaid" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalAmountPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKexpenseID" ColumnName="PKexpenseID" DataSourceName="FHFP.dbo.tblExpense" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKexpenseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKexpenseID" DataSetColumn="PKexpenseID" />
              <Mapping SourceColumn="FKtenderTypeID" DataSetColumn="FKtenderTypeID" />
              <Mapping SourceColumn="FKmemberID" DataSetColumn="FKmemberID" />
              <Mapping SourceColumn="datePurch" DataSetColumn="datePurch" />
              <Mapping SourceColumn="totalAmountPaid" DataSetColumn="totalAmountPaid" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblHouseholdTableAdapter" GeneratorDataComponentClassName="tblHouseholdTableAdapter" Name="tblHousehold" UserDataComponentName="tblHouseholdTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblHousehold" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblHousehold] WHERE (([PKhouseholdID] = @Original_PKhouseholdID) AND ([FKhshldStatusID] = @Original_FKhshldStatusID) AND ([numPeople] = @Original_numPeople) AND ([address] = @Original_address) AND ([city] = @Original_city) AND ([state] = @Original_state) AND ([zip] = @Original_zip) AND ([dateMoveIn] = @Original_dateMoveIn) AND ([name] = @Original_name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numPeople" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numPeople" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateMoveIn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateMoveIn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblHousehold] ([FKhshldStatusID], [numPeople], [address], [city], [state], [zip], [dateMoveIn], [name]) VALUES (@FKhshldStatusID, @numPeople, @address, @city, @state, @zip, @dateMoveIn, @name);
SELECT PKhouseholdID, FKhshldStatusID, numPeople, address, city, state, zip, dateMoveIn, name FROM tblHousehold WHERE (PKhouseholdID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numPeople" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numPeople" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateMoveIn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateMoveIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKhouseholdID, FKhshldStatusID, numPeople, address, city, state, zip, dateMoveIn, name FROM dbo.tblHousehold</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblHousehold] SET [FKhshldStatusID] = @FKhshldStatusID, [numPeople] = @numPeople, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [dateMoveIn] = @dateMoveIn, [name] = @name WHERE (([PKhouseholdID] = @Original_PKhouseholdID) AND ([FKhshldStatusID] = @Original_FKhshldStatusID) AND ([numPeople] = @Original_numPeople) AND ([address] = @Original_address) AND ([city] = @Original_city) AND ([state] = @Original_state) AND ([zip] = @Original_zip) AND ([dateMoveIn] = @Original_dateMoveIn) AND ([name] = @Original_name));
SELECT PKhouseholdID, FKhshldStatusID, numPeople, address, city, state, zip, dateMoveIn, name FROM tblHousehold WHERE (PKhouseholdID = @PKhouseholdID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numPeople" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numPeople" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateMoveIn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateMoveIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numPeople" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numPeople" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_zip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="zip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateMoveIn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateMoveIn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKhouseholdID" ColumnName="PKhouseholdID" DataSourceName="FHFP.dbo.tblHousehold" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKhouseholdID" DataSetColumn="PKhouseholdID" />
              <Mapping SourceColumn="FKhshldStatusID" DataSetColumn="FKhshldStatusID" />
              <Mapping SourceColumn="numPeople" DataSetColumn="numPeople" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="state" DataSetColumn="state" />
              <Mapping SourceColumn="zip" DataSetColumn="zip" />
              <Mapping SourceColumn="dateMoveIn" DataSetColumn="dateMoveIn" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblHsldStatusLUTableAdapter" GeneratorDataComponentClassName="tblHsldStatusLUTableAdapter" Name="tblHsldStatusLU" UserDataComponentName="tblHsldStatusLUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblHsldStatusLU" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblHsldStatusLU] WHERE (([PKhshldStatusID] = @Original_PKhshldStatusID) AND ([householdStatus] = @Original_householdStatus))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_householdStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="householdStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblHsldStatusLU] ([householdStatus]) VALUES (@householdStatus);
SELECT PKhshldStatusID, householdStatus FROM tblHsldStatusLU WHERE (PKhshldStatusID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@householdStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="householdStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKhshldStatusID, householdStatus FROM dbo.tblHsldStatusLU</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblHsldStatusLU] SET [householdStatus] = @householdStatus WHERE (([PKhshldStatusID] = @Original_PKhshldStatusID) AND ([householdStatus] = @Original_householdStatus));
SELECT PKhshldStatusID, householdStatus FROM tblHsldStatusLU WHERE (PKhshldStatusID = @PKhshldStatusID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@householdStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="householdStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_householdStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="householdStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKhshldStatusID" ColumnName="PKhshldStatusID" DataSourceName="FHFP.dbo.tblHsldStatusLU" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKhshldStatusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKhshldStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKhshldStatusID" DataSetColumn="PKhshldStatusID" />
              <Mapping SourceColumn="householdStatus" DataSetColumn="householdStatus" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblItemTypeLUTableAdapter" GeneratorDataComponentClassName="tblItemTypeLUTableAdapter" Name="tblItemTypeLU" UserDataComponentName="tblItemTypeLUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblItemTypeLU" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblItemTypeLU] WHERE (([PKitemTypeID] = @Original_PKitemTypeID) AND ([itemType] = @Original_itemType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_itemType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblItemTypeLU] ([itemType]) VALUES (@itemType);
SELECT PKitemTypeID, itemType FROM tblItemTypeLU WHERE (PKitemTypeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@itemType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKitemTypeID, itemType FROM dbo.tblItemTypeLU</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblItemTypeLU] SET [itemType] = @itemType WHERE (([PKitemTypeID] = @Original_PKitemTypeID) AND ([itemType] = @Original_itemType));
SELECT PKitemTypeID, itemType FROM tblItemTypeLU WHERE (PKitemTypeID = @PKitemTypeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@itemType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_itemType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKitemTypeID" ColumnName="PKitemTypeID" DataSourceName="FHFP.dbo.tblItemTypeLU" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKitemTypeID" DataSetColumn="PKitemTypeID" />
              <Mapping SourceColumn="itemType" DataSetColumn="itemType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblJobInfoTableAdapter" GeneratorDataComponentClassName="tblJobInfoTableAdapter" Name="tblJobInfo" UserDataComponentName="tblJobInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblJobInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblJobInfo] WHERE (([PKjobID] = @Original_PKjobID) AND ([FKmemberID] = @Original_FKmemberID) AND ([FKcompanyID] = @Original_FKcompanyID) AND ((@IsNull_position = 1 AND [position] IS NULL) OR ([position] = @Original_position)) AND ((@IsNull_duties = 1 AND [duties] IS NULL) OR ([duties] = @Original_duties)) AND ([dateStart] = @Original_dateStart) AND ((@IsNull_dateEnd = 1 AND [dateEnd] IS NULL) OR ([dateEnd] = @Original_dateEnd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKjobID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKjobID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_position" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_position" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_duties" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="duties" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_duties" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="duties" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblJobInfo] ([FKmemberID], [FKcompanyID], [position], [duties], [dateStart], [dateEnd]) VALUES (@FKmemberID, @FKcompanyID, @position, @duties, @dateStart, @dateEnd);
SELECT PKjobID, FKmemberID, FKcompanyID, position, duties, dateStart, dateEnd FROM tblJobInfo WHERE (PKjobID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@position" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@duties" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="duties" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKjobID, FKmemberID, FKcompanyID, position, duties, dateStart, dateEnd FROM dbo.tblJobInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblJobInfo] SET [FKmemberID] = @FKmemberID, [FKcompanyID] = @FKcompanyID, [position] = @position, [duties] = @duties, [dateStart] = @dateStart, [dateEnd] = @dateEnd WHERE (([PKjobID] = @Original_PKjobID) AND ([FKmemberID] = @Original_FKmemberID) AND ([FKcompanyID] = @Original_FKcompanyID) AND ((@IsNull_position = 1 AND [position] IS NULL) OR ([position] = @Original_position)) AND ((@IsNull_duties = 1 AND [duties] IS NULL) OR ([duties] = @Original_duties)) AND ([dateStart] = @Original_dateStart) AND ((@IsNull_dateEnd = 1 AND [dateEnd] IS NULL) OR ([dateEnd] = @Original_dateEnd)));
SELECT PKjobID, FKmemberID, FKcompanyID, position, duties, dateStart, dateEnd FROM tblJobInfo WHERE (PKjobID = @PKjobID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@position" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@duties" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="duties" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKjobID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKjobID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKcompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKcompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_position" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_position" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_duties" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="duties" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_duties" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="duties" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKjobID" ColumnName="PKjobID" DataSourceName="FHFP.dbo.tblJobInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKjobID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKjobID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKjobID" DataSetColumn="PKjobID" />
              <Mapping SourceColumn="FKmemberID" DataSetColumn="FKmemberID" />
              <Mapping SourceColumn="FKcompanyID" DataSetColumn="FKcompanyID" />
              <Mapping SourceColumn="position" DataSetColumn="position" />
              <Mapping SourceColumn="duties" DataSetColumn="duties" />
              <Mapping SourceColumn="dateStart" DataSetColumn="dateStart" />
              <Mapping SourceColumn="dateEnd" DataSetColumn="dateEnd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblMemberTableAdapter" GeneratorDataComponentClassName="tblMemberTableAdapter" Name="tblMember" UserDataComponentName="tblMemberTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblMember" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblMember] WHERE (([PKmemberID] = @Original_PKmemberID) AND ([FKhouseholdID] = @Original_FKhouseholdID) AND ([numDependables] = @Original_numDependables) AND ([password] = @Original_password) AND ([fName] = @Original_fName) AND ([lName] = @Original_lName) AND ((@IsNull_dateOfBirth = 1 AND [dateOfBirth] IS NULL) OR ([dateOfBirth] = @Original_dateOfBirth)) AND ((@IsNull_dateLastLogin = 1 AND [dateLastLogin] IS NULL) OR ([dateLastLogin] = @Original_dateLastLogin)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numDependables" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numDependables" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateLastLogin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateLastLogin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastLogin" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblMember] ([FKhouseholdID], [numDependables], [password], [fName], [lName], [dateOfBirth], [dateLastLogin]) VALUES (@FKhouseholdID, @numDependables, @password, @fName, @lName, @dateOfBirth, @dateLastLogin);
SELECT PKmemberID, FKhouseholdID, numDependables, password, fName, lName, dateOfBirth, dateLastLogin FROM tblMember WHERE (PKmemberID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numDependables" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numDependables" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastLogin" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKmemberID, FKhouseholdID, numDependables, password, fName, lName, dateOfBirth, dateLastLogin FROM dbo.tblMember</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblMember] SET [FKhouseholdID] = @FKhouseholdID, [numDependables] = @numDependables, [password] = @password, [fName] = @fName, [lName] = @lName, [dateOfBirth] = @dateOfBirth, [dateLastLogin] = @dateLastLogin WHERE (([PKmemberID] = @Original_PKmemberID) AND ([FKhouseholdID] = @Original_FKhouseholdID) AND ([numDependables] = @Original_numDependables) AND ([password] = @Original_password) AND ([fName] = @Original_fName) AND ([lName] = @Original_lName) AND ((@IsNull_dateOfBirth = 1 AND [dateOfBirth] IS NULL) OR ([dateOfBirth] = @Original_dateOfBirth)) AND ((@IsNull_dateLastLogin = 1 AND [dateLastLogin] IS NULL) OR ([dateLastLogin] = @Original_dateLastLogin)));
SELECT PKmemberID, FKhouseholdID, numDependables, password, fName, lName, dateOfBirth, dateLastLogin FROM tblMember WHERE (PKmemberID = @PKmemberID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numDependables" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numDependables" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastLogin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKhouseholdID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKhouseholdID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numDependables" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numDependables" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateLastLogin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateLastLogin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastLogin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKmemberID" ColumnName="PKmemberID" DataSourceName="FHFP.dbo.tblMember" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKmemberID" DataSetColumn="PKmemberID" />
              <Mapping SourceColumn="FKhouseholdID" DataSetColumn="FKhouseholdID" />
              <Mapping SourceColumn="numDependables" DataSetColumn="numDependables" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="fName" DataSetColumn="fName" />
              <Mapping SourceColumn="lName" DataSetColumn="lName" />
              <Mapping SourceColumn="dateOfBirth" DataSetColumn="dateOfBirth" />
              <Mapping SourceColumn="dateLastLogin" DataSetColumn="dateLastLogin" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblMenuItemTableAdapter" GeneratorDataComponentClassName="tblMenuItemTableAdapter" Name="tblMenuItem" UserDataComponentName="tblMenuItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblMenuItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblMenuItem] WHERE (([PKmenuItemID] = @Original_PKmenuItemID) AND ([FKmenuID] = @Original_FKmenuID) AND ([FKrecieptItemID] = @Original_FKrecieptItemID) AND ([quantity] = @Original_quantity))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKmenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKmenuItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmenuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKrecieptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKrecieptItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblMenuItem] ([FKmenuID], [FKrecieptItemID], [quantity]) VALUES (@FKmenuID, @FKrecieptItemID, @quantity);
SELECT PKmenuItemID, FKmenuID, FKrecieptItemID, quantity FROM tblMenuItem WHERE (PKmenuItemID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmenuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKrecieptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKrecieptItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKmenuItemID, FKmenuID, FKrecieptItemID, quantity FROM dbo.tblMenuItem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblMenuItem] SET [FKmenuID] = @FKmenuID, [FKrecieptItemID] = @FKrecieptItemID, [quantity] = @quantity WHERE (([PKmenuItemID] = @Original_PKmenuItemID) AND ([FKmenuID] = @Original_FKmenuID) AND ([FKrecieptItemID] = @Original_FKrecieptItemID) AND ([quantity] = @Original_quantity));
SELECT PKmenuItemID, FKmenuID, FKrecieptItemID, quantity FROM tblMenuItem WHERE (PKmenuItemID = @PKmenuItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmenuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKrecieptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKrecieptItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKmenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKmenuItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmenuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKrecieptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKrecieptItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKmenuItemID" ColumnName="PKmenuItemID" DataSourceName="FHFP.dbo.tblMenuItem" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKmenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKmenuItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKmenuItemID" DataSetColumn="PKmenuItemID" />
              <Mapping SourceColumn="FKmenuID" DataSetColumn="FKmenuID" />
              <Mapping SourceColumn="FKrecieptItemID" DataSetColumn="FKrecieptItemID" />
              <Mapping SourceColumn="quantity" DataSetColumn="quantity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblMenusTableAdapter" GeneratorDataComponentClassName="tblMenusTableAdapter" Name="tblMenus" UserDataComponentName="tblMenusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblMenus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblMenus] WHERE (([PKmenuID] = @Original_PKmenuID) AND ([FKmemberID] = @Original_FKmemberID) AND ([dateAdded] = @Original_dateAdded) AND ([totalPrice] = @Original_totalPrice) AND ([name] = @Original_name) AND ((@IsNull_datePlanned = 1 AND [datePlanned] IS NULL) OR ([datePlanned] = @Original_datePlanned)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKmenuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_totalPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_datePlanned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="datePlanned" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_datePlanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePlanned" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblMenus] ([FKmemberID], [dateAdded], [totalPrice], [name], [datePlanned]) VALUES (@FKmemberID, @dateAdded, @totalPrice, @name, @datePlanned);
SELECT PKmenuID, FKmemberID, dateAdded, totalPrice, name, datePlanned FROM tblMenus WHERE (PKmenuID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@totalPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@datePlanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePlanned" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKmenuID, FKmemberID, dateAdded, totalPrice, name, datePlanned FROM dbo.tblMenus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblMenus] SET [FKmemberID] = @FKmemberID, [dateAdded] = @dateAdded, [totalPrice] = @totalPrice, [name] = @name, [datePlanned] = @datePlanned WHERE (([PKmenuID] = @Original_PKmenuID) AND ([FKmemberID] = @Original_FKmemberID) AND ([dateAdded] = @Original_dateAdded) AND ([totalPrice] = @Original_totalPrice) AND ([name] = @Original_name) AND ((@IsNull_datePlanned = 1 AND [datePlanned] IS NULL) OR ([datePlanned] = @Original_datePlanned)));
SELECT PKmenuID, FKmemberID, dateAdded, totalPrice, name, datePlanned FROM tblMenus WHERE (PKmenuID = @PKmenuID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@totalPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@datePlanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePlanned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKmenuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAdded" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_totalPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="totalPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_datePlanned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="datePlanned" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_datePlanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="datePlanned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKmenuID" ColumnName="PKmenuID" DataSourceName="FHFP.dbo.tblMenus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKmenuID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKmenuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKmenuID" DataSetColumn="PKmenuID" />
              <Mapping SourceColumn="FKmemberID" DataSetColumn="FKmemberID" />
              <Mapping SourceColumn="dateAdded" DataSetColumn="dateAdded" />
              <Mapping SourceColumn="totalPrice" DataSetColumn="totalPrice" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="datePlanned" DataSetColumn="datePlanned" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblPaycheckTableAdapter" GeneratorDataComponentClassName="tblPaycheckTableAdapter" Name="tblPaycheck" UserDataComponentName="tblPaycheckTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblPaycheck" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblPaycheck] WHERE (([PKpaycheckID] = @Original_PKpaycheckID) AND ([FKmemberID] = @Original_FKmemberID) AND ([FKjobID] = @Original_FKjobID) AND ([date] = @Original_date) AND ([amount] = @Original_amount))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKpaycheckID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKpaycheckID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKjobID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKjobID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_amount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblPaycheck] ([FKmemberID], [FKjobID], [date], [amount]) VALUES (@FKmemberID, @FKjobID, @date, @amount);
SELECT PKpaycheckID, FKmemberID, FKjobID, date, amount FROM tblPaycheck WHERE (PKpaycheckID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKjobID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKjobID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKpaycheckID, FKmemberID, FKjobID, date, amount FROM dbo.tblPaycheck</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblPaycheck] SET [FKmemberID] = @FKmemberID, [FKjobID] = @FKjobID, [date] = @date, [amount] = @amount WHERE (([PKpaycheckID] = @Original_PKpaycheckID) AND ([FKmemberID] = @Original_FKmemberID) AND ([FKjobID] = @Original_FKjobID) AND ([date] = @Original_date) AND ([amount] = @Original_amount));
SELECT PKpaycheckID, FKmemberID, FKjobID, date, amount FROM tblPaycheck WHERE (PKpaycheckID = @PKpaycheckID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKjobID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKjobID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKpaycheckID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKpaycheckID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKjobID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKjobID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_amount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKpaycheckID" ColumnName="PKpaycheckID" DataSourceName="FHFP.dbo.tblPaycheck" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKpaycheckID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKpaycheckID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKpaycheckID" DataSetColumn="PKpaycheckID" />
              <Mapping SourceColumn="FKmemberID" DataSetColumn="FKmemberID" />
              <Mapping SourceColumn="FKjobID" DataSetColumn="FKjobID" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="amount" DataSetColumn="amount" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblPhoneLUTableAdapter" GeneratorDataComponentClassName="tblPhoneLUTableAdapter" Name="tblPhoneLU" UserDataComponentName="tblPhoneLUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblPhoneLU" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblPhoneLU] WHERE (([PKphoneID] = @Original_PKphoneID) AND ([FKmemberID] = @Original_FKmemberID) AND ((@IsNull_phoneType = 1 AND [phoneType] IS NULL) OR ([phoneType] = @Original_phoneType)) AND ([phoneNum] = @Original_phoneNum))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKphoneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKphoneID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phoneType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_phoneType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_phoneNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblPhoneLU] ([FKmemberID], [phoneType], [phoneNum]) VALUES (@FKmemberID, @phoneType, @phoneNum);
SELECT PKphoneID, FKmemberID, phoneType, phoneNum FROM tblPhoneLU WHERE (PKphoneID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phoneType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@phoneNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKphoneID, FKmemberID, phoneType, phoneNum FROM dbo.tblPhoneLU</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblPhoneLU] SET [FKmemberID] = @FKmemberID, [phoneType] = @phoneType, [phoneNum] = @phoneNum WHERE (([PKphoneID] = @Original_PKphoneID) AND ([FKmemberID] = @Original_FKmemberID) AND ((@IsNull_phoneType = 1 AND [phoneType] IS NULL) OR ([phoneType] = @Original_phoneType)) AND ([phoneNum] = @Original_phoneNum));
SELECT PKphoneID, FKmemberID, phoneType, phoneNum FROM tblPhoneLU WHERE (PKphoneID = @PKphoneID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phoneType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@phoneNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKphoneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKphoneID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKmemberID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKmemberID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phoneType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_phoneType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phoneType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_phoneNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phoneNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKphoneID" ColumnName="PKphoneID" DataSourceName="FHFP.dbo.tblPhoneLU" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKphoneID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKphoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKphoneID" DataSetColumn="PKphoneID" />
              <Mapping SourceColumn="FKmemberID" DataSetColumn="FKmemberID" />
              <Mapping SourceColumn="phoneType" DataSetColumn="phoneType" />
              <Mapping SourceColumn="phoneNum" DataSetColumn="phoneNum" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblReceiptTableAdapter" GeneratorDataComponentClassName="tblReceiptTableAdapter" Name="tblReceipt" UserDataComponentName="tblReceiptTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblReceipt" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblReceipt] WHERE (([PKreceiptID] = @Original_PKreceiptID) AND ([FKreceiptItemID] = @Original_FKreceiptItemID) AND ([FKexpenseID] = @Original_FKexpenseID) AND ([quantityOfItem] = @Original_quantityOfItem))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKreceiptID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKreceiptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKexpenseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_quantityOfItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantityOfItem" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblReceipt] ([FKreceiptItemID], [FKexpenseID], [quantityOfItem]) VALUES (@FKreceiptItemID, @FKexpenseID, @quantityOfItem);
SELECT PKreceiptID, FKreceiptItemID, FKexpenseID, quantityOfItem FROM tblReceipt WHERE (PKreceiptID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKexpenseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@quantityOfItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantityOfItem" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKreceiptID, FKreceiptItemID, FKexpenseID, quantityOfItem FROM dbo.tblReceipt</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblReceipt] SET [FKreceiptItemID] = @FKreceiptItemID, [FKexpenseID] = @FKexpenseID, [quantityOfItem] = @quantityOfItem WHERE (([PKreceiptID] = @Original_PKreceiptID) AND ([FKreceiptItemID] = @Original_FKreceiptItemID) AND ([FKexpenseID] = @Original_FKexpenseID) AND ([quantityOfItem] = @Original_quantityOfItem));
SELECT PKreceiptID, FKreceiptItemID, FKexpenseID, quantityOfItem FROM tblReceipt WHERE (PKreceiptID = @PKreceiptID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKexpenseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@quantityOfItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantityOfItem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKreceiptID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKreceiptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKexpenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKexpenseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_quantityOfItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantityOfItem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKreceiptID" ColumnName="PKreceiptID" DataSourceName="FHFP.dbo.tblReceipt" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKreceiptID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKreceiptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKreceiptID" DataSetColumn="PKreceiptID" />
              <Mapping SourceColumn="FKreceiptItemID" DataSetColumn="FKreceiptItemID" />
              <Mapping SourceColumn="FKexpenseID" DataSetColumn="FKexpenseID" />
              <Mapping SourceColumn="quantityOfItem" DataSetColumn="quantityOfItem" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblReceiptItemTableAdapter" GeneratorDataComponentClassName="tblReceiptItemTableAdapter" Name="tblReceiptItem" UserDataComponentName="tblReceiptItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblReceiptItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblReceiptItem] WHERE (([PkreceiptItemID] = @Original_PkreceiptItemID) AND ([FKbrandID] = @Original_FKbrandID) AND ([FKitemTypeID] = @Original_FKitemTypeID) AND ([FKstoreID] = @Original_FKstoreID) AND ([itemName] = @Original_itemName) AND ([price] = @Original_price) AND ((@IsNull_dateLastPurch = 1 AND [dateLastPurch] IS NULL) OR ([dateLastPurch] = @Original_dateLastPurch)) AND ([amount] = @Original_amount))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PkreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PkreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbrandID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKstoreID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_itemName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateLastPurch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateLastPurch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastPurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPurch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_amount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblReceiptItem] ([FKbrandID], [FKitemTypeID], [FKstoreID], [itemName], [price], [dateLastPurch], [amount]) VALUES (@FKbrandID, @FKitemTypeID, @FKstoreID, @itemName, @price, @dateLastPurch, @amount);
SELECT PkreceiptItemID, FKbrandID, FKitemTypeID, FKstoreID, itemName, price, dateLastPurch, amount FROM tblReceiptItem WHERE (PkreceiptItemID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbrandID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKstoreID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@itemName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastPurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPurch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PkreceiptItemID, FKbrandID, FKitemTypeID, FKstoreID, itemName, price, dateLastPurch, amount FROM dbo.tblReceiptItem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblReceiptItem] SET [FKbrandID] = @FKbrandID, [FKitemTypeID] = @FKitemTypeID, [FKstoreID] = @FKstoreID, [itemName] = @itemName, [price] = @price, [dateLastPurch] = @dateLastPurch, [amount] = @amount WHERE (([PkreceiptItemID] = @Original_PkreceiptItemID) AND ([FKbrandID] = @Original_FKbrandID) AND ([FKitemTypeID] = @Original_FKitemTypeID) AND ([FKstoreID] = @Original_FKstoreID) AND ([itemName] = @Original_itemName) AND ([price] = @Original_price) AND ((@IsNull_dateLastPurch = 1 AND [dateLastPurch] IS NULL) OR ([dateLastPurch] = @Original_dateLastPurch)) AND ([amount] = @Original_amount));
SELECT PkreceiptItemID, FKbrandID, FKitemTypeID, FKstoreID, itemName, price, dateLastPurch, amount FROM tblReceiptItem WHERE (PkreceiptItemID = @PkreceiptItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbrandID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKstoreID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@itemName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastPurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPurch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PkreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PkreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKbrandID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKbrandID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKitemTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKitemTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FKstoreID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_itemName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="itemName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateLastPurch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateLastPurch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastPurch" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastPurch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_amount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PkreceiptItemID" ColumnName="PkreceiptItemID" DataSourceName="FHFP.dbo.tblReceiptItem" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PkreceiptItemID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PkreceiptItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PkreceiptItemID" DataSetColumn="PkreceiptItemID" />
              <Mapping SourceColumn="FKbrandID" DataSetColumn="FKbrandID" />
              <Mapping SourceColumn="FKitemTypeID" DataSetColumn="FKitemTypeID" />
              <Mapping SourceColumn="FKstoreID" DataSetColumn="FKstoreID" />
              <Mapping SourceColumn="itemName" DataSetColumn="itemName" />
              <Mapping SourceColumn="price" DataSetColumn="price" />
              <Mapping SourceColumn="dateLastPurch" DataSetColumn="dateLastPurch" />
              <Mapping SourceColumn="amount" DataSetColumn="amount" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblStoreTableAdapter" GeneratorDataComponentClassName="tblStoreTableAdapter" Name="tblStore" UserDataComponentName="tblStoreTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblStore" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblStore] WHERE (([PKstoreID] = @Original_PKstoreID) AND ([name] = @Original_name) AND ([city] = @Original_city) AND ((@IsNull_dateLastVisit = 1 AND [dateLastVisit] IS NULL) OR ([dateLastVisit] = @Original_dateLastVisit)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKstoreID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateLastVisit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateLastVisit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastVisit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastVisit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblStore] ([name], [city], [dateLastVisit]) VALUES (@name, @city, @dateLastVisit);
SELECT PKstoreID, name, city, dateLastVisit FROM tblStore WHERE (PKstoreID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastVisit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastVisit" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKstoreID, name, city, dateLastVisit FROM dbo.tblStore</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblStore] SET [name] = @name, [city] = @city, [dateLastVisit] = @dateLastVisit WHERE (([PKstoreID] = @Original_PKstoreID) AND ([name] = @Original_name) AND ([city] = @Original_city) AND ((@IsNull_dateLastVisit = 1 AND [dateLastVisit] IS NULL) OR ([dateLastVisit] = @Original_dateLastVisit)));
SELECT PKstoreID, name, city, dateLastVisit FROM tblStore WHERE (PKstoreID = @PKstoreID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateLastVisit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastVisit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKstoreID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateLastVisit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dateLastVisit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dateLastVisit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateLastVisit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKstoreID" ColumnName="PKstoreID" DataSourceName="FHFP.dbo.tblStore" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKstoreID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKstoreID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKstoreID" DataSetColumn="PKstoreID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="dateLastVisit" DataSetColumn="dateLastVisit" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTenderTypeLUTableAdapter" GeneratorDataComponentClassName="tblTenderTypeLUTableAdapter" Name="tblTenderTypeLU" UserDataComponentName="tblTenderTypeLUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FHFPConnectionString (Settings)" DbObjectName="FHFP.dbo.tblTenderTypeLU" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblTenderTypeLU] WHERE (([PKtenderTypeID] = @Original_PKtenderTypeID) AND ([tenderType] = @Original_tenderType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_tenderType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tenderType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblTenderTypeLU] ([tenderType]) VALUES (@tenderType);
SELECT PKtenderTypeID, tenderType FROM tblTenderTypeLU WHERE (PKtenderTypeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tenderType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tenderType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PKtenderTypeID, tenderType FROM dbo.tblTenderTypeLU</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblTenderTypeLU] SET [tenderType] = @tenderType WHERE (([PKtenderTypeID] = @Original_PKtenderTypeID) AND ([tenderType] = @Original_tenderType));
SELECT PKtenderTypeID, tenderType FROM tblTenderTypeLU WHERE (PKtenderTypeID = @PKtenderTypeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tenderType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tenderType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_tenderType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tenderType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PKtenderTypeID" ColumnName="PKtenderTypeID" DataSourceName="FHFP.dbo.tblTenderTypeLU" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PKtenderTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PKtenderTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKtenderTypeID" DataSetColumn="PKtenderTypeID" />
              <Mapping SourceColumn="tenderType" DataSetColumn="tenderType" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="FHFPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="FHFPDataSet" msprop:Generator_UserDSName="FHFPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblAppointments" msprop:Generator_TableClassName="tblAppointmentsDataTable" msprop:Generator_TableVarName="tabletblAppointments" msprop:Generator_TablePropName="tblAppointments" msprop:Generator_RowDeletingName="tblAppointmentsRowDeleting" msprop:Generator_RowChangingName="tblAppointmentsRowChanging" msprop:Generator_RowEvHandlerName="tblAppointmentsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblAppointmentsRowDeleted" msprop:Generator_UserTableName="tblAppointments" msprop:Generator_RowChangedName="tblAppointmentsRowChanged" msprop:Generator_RowEvArgName="tblAppointmentsRowChangeEvent" msprop:Generator_RowClassName="tblAppointmentsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKappointmentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKappointmentID" msprop:Generator_ColumnPropNameInRow="PKappointmentID" msprop:Generator_ColumnPropNameInTable="PKappointmentIDColumn" msprop:Generator_UserColumnName="PKappointmentID" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="startTime" msprop:Generator_ColumnVarNameInTable="columnstartTime" msprop:Generator_ColumnPropNameInRow="startTime" msprop:Generator_ColumnPropNameInTable="startTimeColumn" msprop:Generator_UserColumnName="startTime" type="xs:duration" />
              <xs:element name="endTime" msprop:Generator_ColumnVarNameInTable="columnendTime" msprop:Generator_ColumnPropNameInRow="endTime" msprop:Generator_ColumnPropNameInTable="endTimeColumn" msprop:Generator_UserColumnName="endTime" type="xs:duration" />
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" />
              <xs:element name="desciption" msprop:Generator_ColumnVarNameInTable="columndesciption" msprop:Generator_ColumnPropNameInRow="desciption" msprop:Generator_ColumnPropNameInTable="desciptionColumn" msprop:Generator_UserColumnName="desciption">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblBillAccount" msprop:Generator_TableClassName="tblBillAccountDataTable" msprop:Generator_TableVarName="tabletblBillAccount" msprop:Generator_TablePropName="tblBillAccount" msprop:Generator_RowDeletingName="tblBillAccountRowDeleting" msprop:Generator_RowChangingName="tblBillAccountRowChanging" msprop:Generator_RowEvHandlerName="tblBillAccountRowChangeEventHandler" msprop:Generator_RowDeletedName="tblBillAccountRowDeleted" msprop:Generator_UserTableName="tblBillAccount" msprop:Generator_RowChangedName="tblBillAccountRowChanged" msprop:Generator_RowEvArgName="tblBillAccountRowChangeEvent" msprop:Generator_RowClassName="tblBillAccountRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKbillAccountID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKbillAccountID" msprop:Generator_ColumnPropNameInRow="PKbillAccountID" msprop:Generator_ColumnPropNameInTable="PKbillAccountIDColumn" msprop:Generator_UserColumnName="PKbillAccountID" type="xs:int" />
              <xs:element name="FKBillID" msprop:Generator_ColumnVarNameInTable="columnFKBillID" msprop:Generator_ColumnPropNameInRow="FKBillID" msprop:Generator_ColumnPropNameInTable="FKBillIDColumn" msprop:Generator_UserColumnName="FKBillID" type="xs:int" />
              <xs:element name="accountNum" msprop:Generator_ColumnVarNameInTable="columnaccountNum" msprop:Generator_ColumnPropNameInRow="accountNum" msprop:Generator_ColumnPropNameInTable="accountNumColumn" msprop:Generator_UserColumnName="accountNum">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phoneNum" msprop:Generator_ColumnVarNameInTable="columnphoneNum" msprop:Generator_ColumnPropNameInRow="phoneNum" msprop:Generator_ColumnPropNameInTable="phoneNumColumn" msprop:Generator_UserColumnName="phoneNum">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="website" msprop:Generator_ColumnVarNameInTable="columnwebsite" msprop:Generator_ColumnPropNameInRow="website" msprop:Generator_ColumnPropNameInTable="websiteColumn" msprop:Generator_UserColumnName="website" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="login" msprop:Generator_ColumnVarNameInTable="columnlogin" msprop:Generator_ColumnPropNameInRow="login" msprop:Generator_ColumnPropNameInTable="loginColumn" msprop:Generator_UserColumnName="login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblBillResponsible" msprop:Generator_TableClassName="tblBillResponsibleDataTable" msprop:Generator_TableVarName="tabletblBillResponsible" msprop:Generator_TablePropName="tblBillResponsible" msprop:Generator_RowDeletingName="tblBillResponsibleRowDeleting" msprop:Generator_RowChangingName="tblBillResponsibleRowChanging" msprop:Generator_RowEvHandlerName="tblBillResponsibleRowChangeEventHandler" msprop:Generator_RowDeletedName="tblBillResponsibleRowDeleted" msprop:Generator_UserTableName="tblBillResponsible" msprop:Generator_RowChangedName="tblBillResponsibleRowChanged" msprop:Generator_RowEvArgName="tblBillResponsibleRowChangeEvent" msprop:Generator_RowClassName="tblBillResponsibleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKbillRespID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKbillRespID" msprop:Generator_ColumnPropNameInRow="PKbillRespID" msprop:Generator_ColumnPropNameInTable="PKbillRespIDColumn" msprop:Generator_UserColumnName="PKbillRespID" type="xs:int" />
              <xs:element name="FKmemberID" msprop:Generator_ColumnVarNameInTable="columnFKmemberID" msprop:Generator_ColumnPropNameInRow="FKmemberID" msprop:Generator_ColumnPropNameInTable="FKmemberIDColumn" msprop:Generator_UserColumnName="FKmemberID" type="xs:int" />
              <xs:element name="FKbillID" msprop:Generator_ColumnVarNameInTable="columnFKbillID" msprop:Generator_ColumnPropNameInRow="FKbillID" msprop:Generator_ColumnPropNameInTable="FKbillIDColumn" msprop:Generator_UserColumnName="FKbillID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblBills" msprop:Generator_TableClassName="tblBillsDataTable" msprop:Generator_TableVarName="tabletblBills" msprop:Generator_TablePropName="tblBills" msprop:Generator_RowDeletingName="tblBillsRowDeleting" msprop:Generator_RowChangingName="tblBillsRowChanging" msprop:Generator_RowEvHandlerName="tblBillsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblBillsRowDeleted" msprop:Generator_UserTableName="tblBills" msprop:Generator_RowChangedName="tblBillsRowChanged" msprop:Generator_RowEvArgName="tblBillsRowChangeEvent" msprop:Generator_RowClassName="tblBillsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKbillID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKbillID" msprop:Generator_ColumnPropNameInRow="PKbillID" msprop:Generator_ColumnPropNameInTable="PKbillIDColumn" msprop:Generator_UserColumnName="PKbillID" type="xs:int" />
              <xs:element name="FKcompanyID" msprop:Generator_ColumnVarNameInTable="columnFKcompanyID" msprop:Generator_ColumnPropNameInRow="FKcompanyID" msprop:Generator_ColumnPropNameInTable="FKcompanyIDColumn" msprop:Generator_UserColumnName="FKcompanyID" type="xs:int" />
              <xs:element name="billName" msprop:Generator_ColumnVarNameInTable="columnbillName" msprop:Generator_ColumnPropNameInRow="billName" msprop:Generator_ColumnPropNameInTable="billNameColumn" msprop:Generator_UserColumnName="billName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="totalAmountDue" msprop:Generator_ColumnVarNameInTable="columntotalAmountDue" msprop:Generator_ColumnPropNameInRow="totalAmountDue" msprop:Generator_ColumnPropNameInTable="totalAmountDueColumn" msprop:Generator_UserColumnName="totalAmountDue" type="xs:decimal" />
              <xs:element name="eachMemberAmount" msprop:Generator_ColumnVarNameInTable="columneachMemberAmount" msprop:Generator_ColumnPropNameInRow="eachMemberAmount" msprop:Generator_ColumnPropNameInTable="eachMemberAmountColumn" msprop:Generator_UserColumnName="eachMemberAmount" type="xs:decimal" minOccurs="0" />
              <xs:element name="dateDue" msprop:Generator_ColumnVarNameInTable="columndateDue" msprop:Generator_ColumnPropNameInRow="dateDue" msprop:Generator_ColumnPropNameInTable="dateDueColumn" msprop:Generator_UserColumnName="dateDue" type="xs:dateTime" />
              <xs:element name="dateLastPaid" msprop:Generator_ColumnVarNameInTable="columndateLastPaid" msprop:Generator_ColumnPropNameInRow="dateLastPaid" msprop:Generator_ColumnPropNameInTable="dateLastPaidColumn" msprop:Generator_UserColumnName="dateLastPaid" type="xs:dateTime" />
              <xs:element name="dateAdded" msprop:Generator_ColumnVarNameInTable="columndateAdded" msprop:Generator_ColumnPropNameInRow="dateAdded" msprop:Generator_ColumnPropNameInTable="dateAddedColumn" msprop:Generator_UserColumnName="dateAdded" type="xs:dateTime" />
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="paidAmount" msprop:Generator_ColumnVarNameInTable="columnpaidAmount" msprop:Generator_ColumnPropNameInRow="paidAmount" msprop:Generator_ColumnPropNameInTable="paidAmountColumn" msprop:Generator_UserColumnName="paidAmount" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblBrandLU" msprop:Generator_TableClassName="tblBrandLUDataTable" msprop:Generator_TableVarName="tabletblBrandLU" msprop:Generator_TablePropName="tblBrandLU" msprop:Generator_RowDeletingName="tblBrandLURowDeleting" msprop:Generator_RowChangingName="tblBrandLURowChanging" msprop:Generator_RowEvHandlerName="tblBrandLURowChangeEventHandler" msprop:Generator_RowDeletedName="tblBrandLURowDeleted" msprop:Generator_UserTableName="tblBrandLU" msprop:Generator_RowChangedName="tblBrandLURowChanged" msprop:Generator_RowEvArgName="tblBrandLURowChangeEvent" msprop:Generator_RowClassName="tblBrandLURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKbrandID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKbrandID" msprop:Generator_ColumnPropNameInRow="PKbrandID" msprop:Generator_ColumnPropNameInTable="PKbrandIDColumn" msprop:Generator_UserColumnName="PKbrandID" type="xs:int" />
              <xs:element name="brandName" msprop:Generator_ColumnVarNameInTable="columnbrandName" msprop:Generator_ColumnPropNameInRow="brandName" msprop:Generator_ColumnPropNameInTable="brandNameColumn" msprop:Generator_UserColumnName="brandName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCompany" msprop:Generator_TableClassName="tblCompanyDataTable" msprop:Generator_TableVarName="tabletblCompany" msprop:Generator_TablePropName="tblCompany" msprop:Generator_RowDeletingName="tblCompanyRowDeleting" msprop:Generator_RowChangingName="tblCompanyRowChanging" msprop:Generator_RowEvHandlerName="tblCompanyRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCompanyRowDeleted" msprop:Generator_UserTableName="tblCompany" msprop:Generator_RowChangedName="tblCompanyRowChanged" msprop:Generator_RowEvArgName="tblCompanyRowChangeEvent" msprop:Generator_RowClassName="tblCompanyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKcompanyID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKcompanyID" msprop:Generator_ColumnPropNameInRow="PKcompanyID" msprop:Generator_ColumnPropNameInTable="PKcompanyIDColumn" msprop:Generator_UserColumnName="PKcompanyID" type="xs:int" />
              <xs:element name="FKcompTypeID" msprop:Generator_ColumnVarNameInTable="columnFKcompTypeID" msprop:Generator_ColumnPropNameInRow="FKcompTypeID" msprop:Generator_ColumnPropNameInTable="FKcompTypeIDColumn" msprop:Generator_UserColumnName="FKcompTypeID" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_UserColumnName="city">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:Generator_UserColumnName="state">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="zip" msprop:Generator_ColumnVarNameInTable="columnzip" msprop:Generator_ColumnPropNameInRow="zip" msprop:Generator_ColumnPropNameInTable="zipColumn" msprop:Generator_UserColumnName="zip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phoneNum" msprop:Generator_ColumnVarNameInTable="columnphoneNum" msprop:Generator_ColumnPropNameInRow="phoneNum" msprop:Generator_ColumnPropNameInTable="phoneNumColumn" msprop:Generator_UserColumnName="phoneNum" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCompTypeLU" msprop:Generator_TableClassName="tblCompTypeLUDataTable" msprop:Generator_TableVarName="tabletblCompTypeLU" msprop:Generator_TablePropName="tblCompTypeLU" msprop:Generator_RowDeletingName="tblCompTypeLURowDeleting" msprop:Generator_RowChangingName="tblCompTypeLURowChanging" msprop:Generator_RowEvHandlerName="tblCompTypeLURowChangeEventHandler" msprop:Generator_RowDeletedName="tblCompTypeLURowDeleted" msprop:Generator_UserTableName="tblCompTypeLU" msprop:Generator_RowChangedName="tblCompTypeLURowChanged" msprop:Generator_RowEvArgName="tblCompTypeLURowChangeEvent" msprop:Generator_RowClassName="tblCompTypeLURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKcompTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKcompTypeID" msprop:Generator_ColumnPropNameInRow="PKcompTypeID" msprop:Generator_ColumnPropNameInTable="PKcompTypeIDColumn" msprop:Generator_UserColumnName="PKcompTypeID" type="xs:int" />
              <xs:element name="compType" msprop:Generator_ColumnVarNameInTable="columncompType" msprop:Generator_ColumnPropNameInRow="compType" msprop:Generator_ColumnPropNameInTable="compTypeColumn" msprop:Generator_UserColumnName="compType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblExpense" msprop:Generator_TableClassName="tblExpenseDataTable" msprop:Generator_TableVarName="tabletblExpense" msprop:Generator_TablePropName="tblExpense" msprop:Generator_RowDeletingName="tblExpenseRowDeleting" msprop:Generator_RowChangingName="tblExpenseRowChanging" msprop:Generator_RowEvHandlerName="tblExpenseRowChangeEventHandler" msprop:Generator_RowDeletedName="tblExpenseRowDeleted" msprop:Generator_UserTableName="tblExpense" msprop:Generator_RowChangedName="tblExpenseRowChanged" msprop:Generator_RowEvArgName="tblExpenseRowChangeEvent" msprop:Generator_RowClassName="tblExpenseRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKexpenseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKexpenseID" msprop:Generator_ColumnPropNameInRow="PKexpenseID" msprop:Generator_ColumnPropNameInTable="PKexpenseIDColumn" msprop:Generator_UserColumnName="PKexpenseID" type="xs:int" />
              <xs:element name="FKtenderTypeID" msprop:Generator_ColumnVarNameInTable="columnFKtenderTypeID" msprop:Generator_ColumnPropNameInRow="FKtenderTypeID" msprop:Generator_ColumnPropNameInTable="FKtenderTypeIDColumn" msprop:Generator_UserColumnName="FKtenderTypeID" type="xs:int" />
              <xs:element name="FKmemberID" msprop:Generator_ColumnVarNameInTable="columnFKmemberID" msprop:Generator_ColumnPropNameInRow="FKmemberID" msprop:Generator_ColumnPropNameInTable="FKmemberIDColumn" msprop:Generator_UserColumnName="FKmemberID" type="xs:int" />
              <xs:element name="datePurch" msprop:Generator_ColumnVarNameInTable="columndatePurch" msprop:Generator_ColumnPropNameInRow="datePurch" msprop:Generator_ColumnPropNameInTable="datePurchColumn" msprop:Generator_UserColumnName="datePurch" type="xs:dateTime" minOccurs="0" />
              <xs:element name="totalAmountPaid" msprop:Generator_ColumnVarNameInTable="columntotalAmountPaid" msprop:Generator_ColumnPropNameInRow="totalAmountPaid" msprop:Generator_ColumnPropNameInTable="totalAmountPaidColumn" msprop:Generator_UserColumnName="totalAmountPaid" type="xs:decimal" />
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblHousehold" msprop:Generator_TableClassName="tblHouseholdDataTable" msprop:Generator_TableVarName="tabletblHousehold" msprop:Generator_TablePropName="tblHousehold" msprop:Generator_RowDeletingName="tblHouseholdRowDeleting" msprop:Generator_RowChangingName="tblHouseholdRowChanging" msprop:Generator_RowEvHandlerName="tblHouseholdRowChangeEventHandler" msprop:Generator_RowDeletedName="tblHouseholdRowDeleted" msprop:Generator_UserTableName="tblHousehold" msprop:Generator_RowChangedName="tblHouseholdRowChanged" msprop:Generator_RowEvArgName="tblHouseholdRowChangeEvent" msprop:Generator_RowClassName="tblHouseholdRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKhouseholdID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKhouseholdID" msprop:Generator_ColumnPropNameInRow="PKhouseholdID" msprop:Generator_ColumnPropNameInTable="PKhouseholdIDColumn" msprop:Generator_UserColumnName="PKhouseholdID" type="xs:int" />
              <xs:element name="FKhshldStatusID" msprop:Generator_ColumnVarNameInTable="columnFKhshldStatusID" msprop:Generator_ColumnPropNameInRow="FKhshldStatusID" msprop:Generator_ColumnPropNameInTable="FKhshldStatusIDColumn" msprop:Generator_UserColumnName="FKhshldStatusID" type="xs:int" />
              <xs:element name="numPeople" msprop:Generator_ColumnVarNameInTable="columnnumPeople" msprop:Generator_ColumnPropNameInRow="numPeople" msprop:Generator_ColumnPropNameInTable="numPeopleColumn" msprop:Generator_UserColumnName="numPeople" type="xs:int" />
              <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_UserColumnName="city">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:Generator_UserColumnName="state">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="zip" msprop:Generator_ColumnVarNameInTable="columnzip" msprop:Generator_ColumnPropNameInRow="zip" msprop:Generator_ColumnPropNameInTable="zipColumn" msprop:Generator_UserColumnName="zip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateMoveIn" msprop:Generator_ColumnVarNameInTable="columndateMoveIn" msprop:Generator_ColumnPropNameInRow="dateMoveIn" msprop:Generator_ColumnPropNameInTable="dateMoveInColumn" msprop:Generator_UserColumnName="dateMoveIn" type="xs:dateTime" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblHsldStatusLU" msprop:Generator_TableClassName="tblHsldStatusLUDataTable" msprop:Generator_TableVarName="tabletblHsldStatusLU" msprop:Generator_TablePropName="tblHsldStatusLU" msprop:Generator_RowDeletingName="tblHsldStatusLURowDeleting" msprop:Generator_RowChangingName="tblHsldStatusLURowChanging" msprop:Generator_RowEvHandlerName="tblHsldStatusLURowChangeEventHandler" msprop:Generator_RowDeletedName="tblHsldStatusLURowDeleted" msprop:Generator_UserTableName="tblHsldStatusLU" msprop:Generator_RowChangedName="tblHsldStatusLURowChanged" msprop:Generator_RowEvArgName="tblHsldStatusLURowChangeEvent" msprop:Generator_RowClassName="tblHsldStatusLURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKhshldStatusID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKhshldStatusID" msprop:Generator_ColumnPropNameInRow="PKhshldStatusID" msprop:Generator_ColumnPropNameInTable="PKhshldStatusIDColumn" msprop:Generator_UserColumnName="PKhshldStatusID" type="xs:int" />
              <xs:element name="householdStatus" msprop:Generator_ColumnVarNameInTable="columnhouseholdStatus" msprop:Generator_ColumnPropNameInRow="householdStatus" msprop:Generator_ColumnPropNameInTable="householdStatusColumn" msprop:Generator_UserColumnName="householdStatus">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblItemTypeLU" msprop:Generator_TableClassName="tblItemTypeLUDataTable" msprop:Generator_TableVarName="tabletblItemTypeLU" msprop:Generator_TablePropName="tblItemTypeLU" msprop:Generator_RowDeletingName="tblItemTypeLURowDeleting" msprop:Generator_RowChangingName="tblItemTypeLURowChanging" msprop:Generator_RowEvHandlerName="tblItemTypeLURowChangeEventHandler" msprop:Generator_RowDeletedName="tblItemTypeLURowDeleted" msprop:Generator_UserTableName="tblItemTypeLU" msprop:Generator_RowChangedName="tblItemTypeLURowChanged" msprop:Generator_RowEvArgName="tblItemTypeLURowChangeEvent" msprop:Generator_RowClassName="tblItemTypeLURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKitemTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKitemTypeID" msprop:Generator_ColumnPropNameInRow="PKitemTypeID" msprop:Generator_ColumnPropNameInTable="PKitemTypeIDColumn" msprop:Generator_UserColumnName="PKitemTypeID" type="xs:int" />
              <xs:element name="itemType" msprop:Generator_ColumnVarNameInTable="columnitemType" msprop:Generator_ColumnPropNameInRow="itemType" msprop:Generator_ColumnPropNameInTable="itemTypeColumn" msprop:Generator_UserColumnName="itemType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblJobInfo" msprop:Generator_TableClassName="tblJobInfoDataTable" msprop:Generator_TableVarName="tabletblJobInfo" msprop:Generator_TablePropName="tblJobInfo" msprop:Generator_RowDeletingName="tblJobInfoRowDeleting" msprop:Generator_RowChangingName="tblJobInfoRowChanging" msprop:Generator_RowEvHandlerName="tblJobInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="tblJobInfoRowDeleted" msprop:Generator_UserTableName="tblJobInfo" msprop:Generator_RowChangedName="tblJobInfoRowChanged" msprop:Generator_RowEvArgName="tblJobInfoRowChangeEvent" msprop:Generator_RowClassName="tblJobInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKjobID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKjobID" msprop:Generator_ColumnPropNameInRow="PKjobID" msprop:Generator_ColumnPropNameInTable="PKjobIDColumn" msprop:Generator_UserColumnName="PKjobID" type="xs:int" />
              <xs:element name="FKmemberID" msprop:Generator_ColumnVarNameInTable="columnFKmemberID" msprop:Generator_ColumnPropNameInRow="FKmemberID" msprop:Generator_ColumnPropNameInTable="FKmemberIDColumn" msprop:Generator_UserColumnName="FKmemberID" type="xs:int" />
              <xs:element name="FKcompanyID" msprop:Generator_ColumnVarNameInTable="columnFKcompanyID" msprop:Generator_ColumnPropNameInRow="FKcompanyID" msprop:Generator_ColumnPropNameInTable="FKcompanyIDColumn" msprop:Generator_UserColumnName="FKcompanyID" type="xs:int" />
              <xs:element name="position" msprop:Generator_ColumnVarNameInTable="columnposition" msprop:Generator_ColumnPropNameInRow="position" msprop:Generator_ColumnPropNameInTable="positionColumn" msprop:Generator_UserColumnName="position" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="duties" msprop:Generator_ColumnVarNameInTable="columnduties" msprop:Generator_ColumnPropNameInRow="duties" msprop:Generator_ColumnPropNameInTable="dutiesColumn" msprop:Generator_UserColumnName="duties" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateStart" msprop:Generator_ColumnVarNameInTable="columndateStart" msprop:Generator_ColumnPropNameInRow="dateStart" msprop:Generator_ColumnPropNameInTable="dateStartColumn" msprop:Generator_UserColumnName="dateStart" type="xs:dateTime" />
              <xs:element name="dateEnd" msprop:Generator_ColumnVarNameInTable="columndateEnd" msprop:Generator_ColumnPropNameInRow="dateEnd" msprop:Generator_ColumnPropNameInTable="dateEndColumn" msprop:Generator_UserColumnName="dateEnd" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblMember" msprop:Generator_TableClassName="tblMemberDataTable" msprop:Generator_TableVarName="tabletblMember" msprop:Generator_TablePropName="tblMember" msprop:Generator_RowDeletingName="tblMemberRowDeleting" msprop:Generator_RowChangingName="tblMemberRowChanging" msprop:Generator_RowEvHandlerName="tblMemberRowChangeEventHandler" msprop:Generator_RowDeletedName="tblMemberRowDeleted" msprop:Generator_UserTableName="tblMember" msprop:Generator_RowChangedName="tblMemberRowChanged" msprop:Generator_RowEvArgName="tblMemberRowChangeEvent" msprop:Generator_RowClassName="tblMemberRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKmemberID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKmemberID" msprop:Generator_ColumnPropNameInRow="PKmemberID" msprop:Generator_ColumnPropNameInTable="PKmemberIDColumn" msprop:Generator_UserColumnName="PKmemberID" type="xs:int" />
              <xs:element name="FKhouseholdID" msprop:Generator_ColumnVarNameInTable="columnFKhouseholdID" msprop:Generator_ColumnPropNameInRow="FKhouseholdID" msprop:Generator_ColumnPropNameInTable="FKhouseholdIDColumn" msprop:Generator_UserColumnName="FKhouseholdID" type="xs:int" />
              <xs:element name="numDependables" msprop:Generator_ColumnVarNameInTable="columnnumDependables" msprop:Generator_ColumnPropNameInRow="numDependables" msprop:Generator_ColumnPropNameInTable="numDependablesColumn" msprop:Generator_UserColumnName="numDependables" type="xs:int" />
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fName" msprop:Generator_ColumnVarNameInTable="columnfName" msprop:Generator_ColumnPropNameInRow="fName" msprop:Generator_ColumnPropNameInTable="fNameColumn" msprop:Generator_UserColumnName="fName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lName" msprop:Generator_ColumnVarNameInTable="columnlName" msprop:Generator_ColumnPropNameInRow="lName" msprop:Generator_ColumnPropNameInTable="lNameColumn" msprop:Generator_UserColumnName="lName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateOfBirth" msprop:Generator_ColumnVarNameInTable="columndateOfBirth" msprop:Generator_ColumnPropNameInRow="dateOfBirth" msprop:Generator_ColumnPropNameInTable="dateOfBirthColumn" msprop:Generator_UserColumnName="dateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dateLastLogin" msprop:Generator_ColumnVarNameInTable="columndateLastLogin" msprop:Generator_ColumnPropNameInRow="dateLastLogin" msprop:Generator_ColumnPropNameInTable="dateLastLoginColumn" msprop:Generator_UserColumnName="dateLastLogin" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblMenuItem" msprop:Generator_TableClassName="tblMenuItemDataTable" msprop:Generator_TableVarName="tabletblMenuItem" msprop:Generator_TablePropName="tblMenuItem" msprop:Generator_RowDeletingName="tblMenuItemRowDeleting" msprop:Generator_RowChangingName="tblMenuItemRowChanging" msprop:Generator_RowEvHandlerName="tblMenuItemRowChangeEventHandler" msprop:Generator_RowDeletedName="tblMenuItemRowDeleted" msprop:Generator_UserTableName="tblMenuItem" msprop:Generator_RowChangedName="tblMenuItemRowChanged" msprop:Generator_RowEvArgName="tblMenuItemRowChangeEvent" msprop:Generator_RowClassName="tblMenuItemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKmenuItemID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKmenuItemID" msprop:Generator_ColumnPropNameInRow="PKmenuItemID" msprop:Generator_ColumnPropNameInTable="PKmenuItemIDColumn" msprop:Generator_UserColumnName="PKmenuItemID" type="xs:int" />
              <xs:element name="FKmenuID" msprop:Generator_ColumnVarNameInTable="columnFKmenuID" msprop:Generator_ColumnPropNameInRow="FKmenuID" msprop:Generator_ColumnPropNameInTable="FKmenuIDColumn" msprop:Generator_UserColumnName="FKmenuID" type="xs:int" />
              <xs:element name="FKrecieptItemID" msprop:Generator_ColumnVarNameInTable="columnFKrecieptItemID" msprop:Generator_ColumnPropNameInRow="FKrecieptItemID" msprop:Generator_ColumnPropNameInTable="FKrecieptItemIDColumn" msprop:Generator_UserColumnName="FKrecieptItemID" type="xs:int" />
              <xs:element name="quantity" msprop:Generator_ColumnVarNameInTable="columnquantity" msprop:Generator_ColumnPropNameInRow="quantity" msprop:Generator_ColumnPropNameInTable="quantityColumn" msprop:Generator_UserColumnName="quantity" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblMenus" msprop:Generator_TableClassName="tblMenusDataTable" msprop:Generator_TableVarName="tabletblMenus" msprop:Generator_TablePropName="tblMenus" msprop:Generator_RowDeletingName="tblMenusRowDeleting" msprop:Generator_RowChangingName="tblMenusRowChanging" msprop:Generator_RowEvHandlerName="tblMenusRowChangeEventHandler" msprop:Generator_RowDeletedName="tblMenusRowDeleted" msprop:Generator_UserTableName="tblMenus" msprop:Generator_RowChangedName="tblMenusRowChanged" msprop:Generator_RowEvArgName="tblMenusRowChangeEvent" msprop:Generator_RowClassName="tblMenusRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKmenuID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKmenuID" msprop:Generator_ColumnPropNameInRow="PKmenuID" msprop:Generator_ColumnPropNameInTable="PKmenuIDColumn" msprop:Generator_UserColumnName="PKmenuID" type="xs:int" />
              <xs:element name="FKmemberID" msprop:Generator_ColumnVarNameInTable="columnFKmemberID" msprop:Generator_ColumnPropNameInRow="FKmemberID" msprop:Generator_ColumnPropNameInTable="FKmemberIDColumn" msprop:Generator_UserColumnName="FKmemberID" type="xs:int" />
              <xs:element name="dateAdded" msprop:Generator_ColumnVarNameInTable="columndateAdded" msprop:Generator_ColumnPropNameInRow="dateAdded" msprop:Generator_ColumnPropNameInTable="dateAddedColumn" msprop:Generator_UserColumnName="dateAdded" type="xs:dateTime" />
              <xs:element name="totalPrice" msprop:Generator_ColumnVarNameInTable="columntotalPrice" msprop:Generator_ColumnPropNameInRow="totalPrice" msprop:Generator_ColumnPropNameInTable="totalPriceColumn" msprop:Generator_UserColumnName="totalPrice" type="xs:decimal" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="datePlanned" msprop:Generator_ColumnVarNameInTable="columndatePlanned" msprop:Generator_ColumnPropNameInRow="datePlanned" msprop:Generator_ColumnPropNameInTable="datePlannedColumn" msprop:Generator_UserColumnName="datePlanned" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblPaycheck" msprop:Generator_TableClassName="tblPaycheckDataTable" msprop:Generator_TableVarName="tabletblPaycheck" msprop:Generator_TablePropName="tblPaycheck" msprop:Generator_RowDeletingName="tblPaycheckRowDeleting" msprop:Generator_RowChangingName="tblPaycheckRowChanging" msprop:Generator_RowEvHandlerName="tblPaycheckRowChangeEventHandler" msprop:Generator_RowDeletedName="tblPaycheckRowDeleted" msprop:Generator_UserTableName="tblPaycheck" msprop:Generator_RowChangedName="tblPaycheckRowChanged" msprop:Generator_RowEvArgName="tblPaycheckRowChangeEvent" msprop:Generator_RowClassName="tblPaycheckRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKpaycheckID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKpaycheckID" msprop:Generator_ColumnPropNameInRow="PKpaycheckID" msprop:Generator_ColumnPropNameInTable="PKpaycheckIDColumn" msprop:Generator_UserColumnName="PKpaycheckID" type="xs:int" />
              <xs:element name="FKmemberID" msprop:Generator_ColumnVarNameInTable="columnFKmemberID" msprop:Generator_ColumnPropNameInRow="FKmemberID" msprop:Generator_ColumnPropNameInTable="FKmemberIDColumn" msprop:Generator_UserColumnName="FKmemberID" type="xs:int" />
              <xs:element name="FKjobID" msprop:Generator_ColumnVarNameInTable="columnFKjobID" msprop:Generator_ColumnPropNameInRow="FKjobID" msprop:Generator_ColumnPropNameInTable="FKjobIDColumn" msprop:Generator_UserColumnName="FKjobID" type="xs:int" />
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" />
              <xs:element name="amount" msprop:Generator_ColumnVarNameInTable="columnamount" msprop:Generator_ColumnPropNameInRow="amount" msprop:Generator_ColumnPropNameInTable="amountColumn" msprop:Generator_UserColumnName="amount" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblPhoneLU" msprop:Generator_TableClassName="tblPhoneLUDataTable" msprop:Generator_TableVarName="tabletblPhoneLU" msprop:Generator_TablePropName="tblPhoneLU" msprop:Generator_RowDeletingName="tblPhoneLURowDeleting" msprop:Generator_RowChangingName="tblPhoneLURowChanging" msprop:Generator_RowEvHandlerName="tblPhoneLURowChangeEventHandler" msprop:Generator_RowDeletedName="tblPhoneLURowDeleted" msprop:Generator_UserTableName="tblPhoneLU" msprop:Generator_RowChangedName="tblPhoneLURowChanged" msprop:Generator_RowEvArgName="tblPhoneLURowChangeEvent" msprop:Generator_RowClassName="tblPhoneLURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKphoneID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKphoneID" msprop:Generator_ColumnPropNameInRow="PKphoneID" msprop:Generator_ColumnPropNameInTable="PKphoneIDColumn" msprop:Generator_UserColumnName="PKphoneID" type="xs:int" />
              <xs:element name="FKmemberID" msprop:Generator_ColumnVarNameInTable="columnFKmemberID" msprop:Generator_ColumnPropNameInRow="FKmemberID" msprop:Generator_ColumnPropNameInTable="FKmemberIDColumn" msprop:Generator_UserColumnName="FKmemberID" type="xs:int" />
              <xs:element name="phoneType" msprop:Generator_ColumnVarNameInTable="columnphoneType" msprop:Generator_ColumnPropNameInRow="phoneType" msprop:Generator_ColumnPropNameInTable="phoneTypeColumn" msprop:Generator_UserColumnName="phoneType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phoneNum" msprop:Generator_ColumnVarNameInTable="columnphoneNum" msprop:Generator_ColumnPropNameInRow="phoneNum" msprop:Generator_ColumnPropNameInTable="phoneNumColumn" msprop:Generator_UserColumnName="phoneNum" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblReceipt" msprop:Generator_TableClassName="tblReceiptDataTable" msprop:Generator_TableVarName="tabletblReceipt" msprop:Generator_TablePropName="tblReceipt" msprop:Generator_RowDeletingName="tblReceiptRowDeleting" msprop:Generator_RowChangingName="tblReceiptRowChanging" msprop:Generator_RowEvHandlerName="tblReceiptRowChangeEventHandler" msprop:Generator_RowDeletedName="tblReceiptRowDeleted" msprop:Generator_UserTableName="tblReceipt" msprop:Generator_RowChangedName="tblReceiptRowChanged" msprop:Generator_RowEvArgName="tblReceiptRowChangeEvent" msprop:Generator_RowClassName="tblReceiptRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKreceiptID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKreceiptID" msprop:Generator_ColumnPropNameInRow="PKreceiptID" msprop:Generator_ColumnPropNameInTable="PKreceiptIDColumn" msprop:Generator_UserColumnName="PKreceiptID" type="xs:int" />
              <xs:element name="FKreceiptItemID" msprop:Generator_ColumnVarNameInTable="columnFKreceiptItemID" msprop:Generator_ColumnPropNameInRow="FKreceiptItemID" msprop:Generator_ColumnPropNameInTable="FKreceiptItemIDColumn" msprop:Generator_UserColumnName="FKreceiptItemID" type="xs:int" />
              <xs:element name="FKexpenseID" msprop:Generator_ColumnVarNameInTable="columnFKexpenseID" msprop:Generator_ColumnPropNameInRow="FKexpenseID" msprop:Generator_ColumnPropNameInTable="FKexpenseIDColumn" msprop:Generator_UserColumnName="FKexpenseID" type="xs:int" />
              <xs:element name="quantityOfItem" msprop:Generator_ColumnVarNameInTable="columnquantityOfItem" msprop:Generator_ColumnPropNameInRow="quantityOfItem" msprop:Generator_ColumnPropNameInTable="quantityOfItemColumn" msprop:Generator_UserColumnName="quantityOfItem" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblReceiptItem" msprop:Generator_TableClassName="tblReceiptItemDataTable" msprop:Generator_TableVarName="tabletblReceiptItem" msprop:Generator_TablePropName="tblReceiptItem" msprop:Generator_RowDeletingName="tblReceiptItemRowDeleting" msprop:Generator_RowChangingName="tblReceiptItemRowChanging" msprop:Generator_RowEvHandlerName="tblReceiptItemRowChangeEventHandler" msprop:Generator_RowDeletedName="tblReceiptItemRowDeleted" msprop:Generator_UserTableName="tblReceiptItem" msprop:Generator_RowChangedName="tblReceiptItemRowChanged" msprop:Generator_RowEvArgName="tblReceiptItemRowChangeEvent" msprop:Generator_RowClassName="tblReceiptItemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PkreceiptItemID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPkreceiptItemID" msprop:Generator_ColumnPropNameInRow="PkreceiptItemID" msprop:Generator_ColumnPropNameInTable="PkreceiptItemIDColumn" msprop:Generator_UserColumnName="PkreceiptItemID" type="xs:int" />
              <xs:element name="FKbrandID" msprop:Generator_ColumnVarNameInTable="columnFKbrandID" msprop:Generator_ColumnPropNameInRow="FKbrandID" msprop:Generator_ColumnPropNameInTable="FKbrandIDColumn" msprop:Generator_UserColumnName="FKbrandID" type="xs:int" />
              <xs:element name="FKitemTypeID" msprop:Generator_ColumnVarNameInTable="columnFKitemTypeID" msprop:Generator_ColumnPropNameInRow="FKitemTypeID" msprop:Generator_ColumnPropNameInTable="FKitemTypeIDColumn" msprop:Generator_UserColumnName="FKitemTypeID" type="xs:int" />
              <xs:element name="FKstoreID" msprop:Generator_ColumnVarNameInTable="columnFKstoreID" msprop:Generator_ColumnPropNameInRow="FKstoreID" msprop:Generator_ColumnPropNameInTable="FKstoreIDColumn" msprop:Generator_UserColumnName="FKstoreID" type="xs:int" />
              <xs:element name="itemName" msprop:Generator_ColumnVarNameInTable="columnitemName" msprop:Generator_ColumnPropNameInRow="itemName" msprop:Generator_ColumnPropNameInTable="itemNameColumn" msprop:Generator_UserColumnName="itemName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" type="xs:decimal" />
              <xs:element name="dateLastPurch" msprop:Generator_ColumnVarNameInTable="columndateLastPurch" msprop:Generator_ColumnPropNameInRow="dateLastPurch" msprop:Generator_ColumnPropNameInTable="dateLastPurchColumn" msprop:Generator_UserColumnName="dateLastPurch" type="xs:dateTime" minOccurs="0" />
              <xs:element name="amount" msprop:Generator_ColumnVarNameInTable="columnamount" msprop:Generator_ColumnPropNameInRow="amount" msprop:Generator_ColumnPropNameInTable="amountColumn" msprop:Generator_UserColumnName="amount">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblStore" msprop:Generator_TableClassName="tblStoreDataTable" msprop:Generator_TableVarName="tabletblStore" msprop:Generator_TablePropName="tblStore" msprop:Generator_RowDeletingName="tblStoreRowDeleting" msprop:Generator_RowChangingName="tblStoreRowChanging" msprop:Generator_RowEvHandlerName="tblStoreRowChangeEventHandler" msprop:Generator_RowDeletedName="tblStoreRowDeleted" msprop:Generator_UserTableName="tblStore" msprop:Generator_RowChangedName="tblStoreRowChanged" msprop:Generator_RowEvArgName="tblStoreRowChangeEvent" msprop:Generator_RowClassName="tblStoreRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKstoreID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKstoreID" msprop:Generator_ColumnPropNameInRow="PKstoreID" msprop:Generator_ColumnPropNameInTable="PKstoreIDColumn" msprop:Generator_UserColumnName="PKstoreID" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_UserColumnName="city">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateLastVisit" msprop:Generator_ColumnVarNameInTable="columndateLastVisit" msprop:Generator_ColumnPropNameInRow="dateLastVisit" msprop:Generator_ColumnPropNameInTable="dateLastVisitColumn" msprop:Generator_UserColumnName="dateLastVisit" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTenderTypeLU" msprop:Generator_TableClassName="tblTenderTypeLUDataTable" msprop:Generator_TableVarName="tabletblTenderTypeLU" msprop:Generator_TablePropName="tblTenderTypeLU" msprop:Generator_RowDeletingName="tblTenderTypeLURowDeleting" msprop:Generator_RowChangingName="tblTenderTypeLURowChanging" msprop:Generator_RowEvHandlerName="tblTenderTypeLURowChangeEventHandler" msprop:Generator_RowDeletedName="tblTenderTypeLURowDeleted" msprop:Generator_UserTableName="tblTenderTypeLU" msprop:Generator_RowChangedName="tblTenderTypeLURowChanged" msprop:Generator_RowEvArgName="tblTenderTypeLURowChangeEvent" msprop:Generator_RowClassName="tblTenderTypeLURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKtenderTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPKtenderTypeID" msprop:Generator_ColumnPropNameInRow="PKtenderTypeID" msprop:Generator_ColumnPropNameInTable="PKtenderTypeIDColumn" msprop:Generator_UserColumnName="PKtenderTypeID" type="xs:int" />
              <xs:element name="tenderType" msprop:Generator_ColumnVarNameInTable="columntenderType" msprop:Generator_ColumnPropNameInRow="tenderType" msprop:Generator_ColumnPropNameInTable="tenderTypeColumn" msprop:Generator_UserColumnName="tenderType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAppointments" />
      <xs:field xpath="mstns:PKappointmentID" />
    </xs:unique>
    <xs:unique name="tblBillAccount_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblBillAccount" />
      <xs:field xpath="mstns:PKbillAccountID" />
    </xs:unique>
    <xs:unique name="tblBillResponsible_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblBillResponsible" />
      <xs:field xpath="mstns:PKbillRespID" />
    </xs:unique>
    <xs:unique name="tblBills_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblBills" />
      <xs:field xpath="mstns:PKbillID" />
    </xs:unique>
    <xs:unique name="tblBrandLU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblBrandLU" />
      <xs:field xpath="mstns:PKbrandID" />
    </xs:unique>
    <xs:unique name="tblCompany_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCompany" />
      <xs:field xpath="mstns:PKcompanyID" />
    </xs:unique>
    <xs:unique name="tblCompTypeLU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCompTypeLU" />
      <xs:field xpath="mstns:PKcompTypeID" />
    </xs:unique>
    <xs:unique name="tblExpense_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblExpense" />
      <xs:field xpath="mstns:PKexpenseID" />
    </xs:unique>
    <xs:unique name="tblHousehold_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblHousehold" />
      <xs:field xpath="mstns:PKhouseholdID" />
    </xs:unique>
    <xs:unique name="tblHsldStatusLU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblHsldStatusLU" />
      <xs:field xpath="mstns:PKhshldStatusID" />
    </xs:unique>
    <xs:unique name="tblItemTypeLU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblItemTypeLU" />
      <xs:field xpath="mstns:PKitemTypeID" />
    </xs:unique>
    <xs:unique name="tblJobInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblJobInfo" />
      <xs:field xpath="mstns:PKjobID" />
    </xs:unique>
    <xs:unique name="tblMember_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblMember" />
      <xs:field xpath="mstns:PKmemberID" />
    </xs:unique>
    <xs:unique name="tblMenuItem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblMenuItem" />
      <xs:field xpath="mstns:PKmenuItemID" />
    </xs:unique>
    <xs:unique name="tblMenus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblMenus" />
      <xs:field xpath="mstns:PKmenuID" />
    </xs:unique>
    <xs:unique name="tblPaycheck_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblPaycheck" />
      <xs:field xpath="mstns:PKpaycheckID" />
    </xs:unique>
    <xs:unique name="tblPhoneLU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblPhoneLU" />
      <xs:field xpath="mstns:PKphoneID" />
    </xs:unique>
    <xs:unique name="tblReceipt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblReceipt" />
      <xs:field xpath="mstns:PKreceiptID" />
    </xs:unique>
    <xs:unique name="tblReceiptItem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblReceiptItem" />
      <xs:field xpath="mstns:PkreceiptItemID" />
    </xs:unique>
    <xs:unique name="tblStore_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblStore" />
      <xs:field xpath="mstns:PKstoreID" />
    </xs:unique>
    <xs:unique name="tblTenderTypeLU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTenderTypeLU" />
      <xs:field xpath="mstns:PKtenderTypeID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="Bill_x0020_Account_x0020_has_x0020_One_x0020_Bill" msdata:parent="tblBills" msdata:child="tblBillAccount" msdata:parentkey="PKbillID" msdata:childkey="FKBillID" msprop:Generator_UserChildTable="tblBillAccount" msprop:Generator_ChildPropName="GettblBillAccountRows" msprop:Generator_UserRelationName="Bill Account has One Bill" msprop:Generator_RelationVarName="relationBill_Account_has_One_Bill" msprop:Generator_UserParentTable="tblBills" msprop:Generator_ParentPropName="tblBillsRow" />
      <msdata:Relationship name="Bill_x0020_can_x0020_have_x0020_many_x0020_BillResponsible" msdata:parent="tblBills" msdata:child="tblBillResponsible" msdata:parentkey="PKbillID" msdata:childkey="FKbillID" msprop:Generator_UserChildTable="tblBillResponsible" msprop:Generator_ChildPropName="GettblBillResponsibleRows" msprop:Generator_UserRelationName="Bill can have many BillResponsible" msprop:Generator_RelationVarName="relationBill_can_have_many_BillResponsible" msprop:Generator_UserParentTable="tblBills" msprop:Generator_ParentPropName="tblBillsRow" />
      <msdata:Relationship name="Member_x0020_can_x0020_have_x0020_many_x0020_BillResponsible" msdata:parent="tblMember" msdata:child="tblBillResponsible" msdata:parentkey="PKmemberID" msdata:childkey="FKmemberID" msprop:Generator_UserChildTable="tblBillResponsible" msprop:Generator_ChildPropName="GettblBillResponsibleRows" msprop:Generator_UserRelationName="Member can have many BillResponsible" msprop:Generator_RelationVarName="relationMember_can_have_many_BillResponsible" msprop:Generator_UserParentTable="tblMember" msprop:Generator_ParentPropName="tblMemberRow" />
      <msdata:Relationship name="Bills_x0020_has_x0020_one_x0020_Company" msdata:parent="tblCompany" msdata:child="tblBills" msdata:parentkey="PKcompanyID" msdata:childkey="FKcompanyID" msprop:Generator_UserChildTable="tblBills" msprop:Generator_ChildPropName="GettblBillsRows" msprop:Generator_UserRelationName="Bills has one Company" msprop:Generator_RelationVarName="relationBills_has_one_Company" msprop:Generator_UserParentTable="tblCompany" msprop:Generator_ParentPropName="tblCompanyRow" />
      <msdata:Relationship name="Company_x0020_can_x0020_have_x0020_one_x0020_CompanyType" msdata:parent="tblCompTypeLU" msdata:child="tblCompany" msdata:parentkey="PKcompTypeID" msdata:childkey="FKcompTypeID" msprop:Generator_UserChildTable="tblCompany" msprop:Generator_ChildPropName="GettblCompanyRows" msprop:Generator_UserRelationName="Company can have one CompanyType" msprop:Generator_RelationVarName="relationCompany_can_have_one_CompanyType" msprop:Generator_UserParentTable="tblCompTypeLU" msprop:Generator_ParentPropName="tblCompTypeLURow" />
      <msdata:Relationship name="Expense_x0020_has_x0020_one_x0020_TenderType" msdata:parent="tblTenderTypeLU" msdata:child="tblExpense" msdata:parentkey="PKtenderTypeID" msdata:childkey="FKtenderTypeID" msprop:Generator_UserChildTable="tblExpense" msprop:Generator_ChildPropName="GettblExpenseRows" msprop:Generator_UserRelationName="Expense has one TenderType" msprop:Generator_RelationVarName="relationExpense_has_one_TenderType" msprop:Generator_UserParentTable="tblTenderTypeLU" msprop:Generator_ParentPropName="tblTenderTypeLURow" />
      <msdata:Relationship name="Member_x0020_can_x0020_have_x0020_many_x0020_Expenses" msdata:parent="tblMember" msdata:child="tblExpense" msdata:parentkey="PKmemberID" msdata:childkey="FKmemberID" msprop:Generator_UserChildTable="tblExpense" msprop:Generator_ChildPropName="GettblExpenseRows" msprop:Generator_UserRelationName="Member can have many Expenses" msprop:Generator_RelationVarName="relationMember_can_have_many_Expenses" msprop:Generator_UserParentTable="tblMember" msprop:Generator_ParentPropName="tblMemberRow" />
      <msdata:Relationship name="Household_x0020_has_x0020_one_x0020_hsldStatus" msdata:parent="tblHsldStatusLU" msdata:child="tblHousehold" msdata:parentkey="PKhshldStatusID" msdata:childkey="FKhshldStatusID" msprop:Generator_UserChildTable="tblHousehold" msprop:Generator_ChildPropName="GettblHouseholdRows" msprop:Generator_UserRelationName="Household has one hsldStatus" msprop:Generator_RelationVarName="relationHousehold_has_one_hsldStatus" msprop:Generator_UserParentTable="tblHsldStatusLU" msprop:Generator_ParentPropName="tblHsldStatusLURow" />
      <msdata:Relationship name="JobInfo_x0020_has_x0020_one_x0020_Company" msdata:parent="tblCompany" msdata:child="tblJobInfo" msdata:parentkey="PKcompanyID" msdata:childkey="FKcompanyID" msprop:Generator_UserChildTable="tblJobInfo" msprop:Generator_ChildPropName="GettblJobInfoRows" msprop:Generator_UserRelationName="JobInfo has one Company" msprop:Generator_ParentPropName="tblCompanyRow" msprop:Generator_RelationVarName="relationJobInfo_has_one_Company" msprop:Generator_UserParentTable="tblCompany" />
      <msdata:Relationship name="Member_x0020_can_x0020_have_x0020_many_x0020_JobInfo" msdata:parent="tblMember" msdata:child="tblJobInfo" msdata:parentkey="PKmemberID" msdata:childkey="FKmemberID" msprop:Generator_UserChildTable="tblJobInfo" msprop:Generator_ChildPropName="GettblJobInfoRows" msprop:Generator_UserRelationName="Member can have many JobInfo" msprop:Generator_RelationVarName="relationMember_can_have_many_JobInfo" msprop:Generator_UserParentTable="tblMember" msprop:Generator_ParentPropName="tblMemberRow" />
      <msdata:Relationship name="Household_x0020_has_x0020_many_x0020_Members" msdata:parent="tblHousehold" msdata:child="tblMember" msdata:parentkey="PKhouseholdID" msdata:childkey="FKhouseholdID" msprop:Generator_UserChildTable="tblMember" msprop:Generator_ChildPropName="GettblMemberRows" msprop:Generator_UserRelationName="Household has many Members" msprop:Generator_ParentPropName="tblHouseholdRow" msprop:Generator_RelationVarName="relationHousehold_has_many_Members" msprop:Generator_UserParentTable="tblHousehold" />
      <msdata:Relationship name="MenuItem_x0020_has_x0020_one_x0020_RecieptItem" msdata:parent="tblReceiptItem" msdata:child="tblMenuItem" msdata:parentkey="PkreceiptItemID" msdata:childkey="FKrecieptItemID" msprop:Generator_UserChildTable="tblMenuItem" msprop:Generator_ChildPropName="GettblMenuItemRows" msprop:Generator_UserRelationName="MenuItem has one RecieptItem" msprop:Generator_RelationVarName="relationMenuItem_has_one_RecieptItem" msprop:Generator_UserParentTable="tblReceiptItem" msprop:Generator_ParentPropName="tblReceiptItemRow" />
      <msdata:Relationship name="Menus_x0020_may_x0020_have_x0020_many_x0020_MenuItems" msdata:parent="tblMenus" msdata:child="tblMenuItem" msdata:parentkey="PKmenuID" msdata:childkey="FKmenuID" msprop:Generator_UserChildTable="tblMenuItem" msprop:Generator_ChildPropName="GettblMenuItemRows" msprop:Generator_UserRelationName="Menus may have many MenuItems" msprop:Generator_RelationVarName="relationMenus_may_have_many_MenuItems" msprop:Generator_UserParentTable="tblMenus" msprop:Generator_ParentPropName="tblMenusRow" />
      <msdata:Relationship name="Member_x0020_may_x0020_have_x0020_many_x0020_Menus" msdata:parent="tblMember" msdata:child="tblMenus" msdata:parentkey="PKmemberID" msdata:childkey="FKmemberID" msprop:Generator_UserChildTable="tblMenus" msprop:Generator_ChildPropName="GettblMenusRows" msprop:Generator_UserRelationName="Member may have many Menus" msprop:Generator_ParentPropName="tblMemberRow" msprop:Generator_RelationVarName="relationMember_may_have_many_Menus" msprop:Generator_UserParentTable="tblMember" />
      <msdata:Relationship name="JobInfo_x0020_can_x0020_have_x0020_many_x0020_Paychecks" msdata:parent="tblJobInfo" msdata:child="tblPaycheck" msdata:parentkey="PKjobID" msdata:childkey="FKjobID" msprop:Generator_UserChildTable="tblPaycheck" msprop:Generator_ChildPropName="GettblPaycheckRows" msprop:Generator_UserRelationName="JobInfo can have many Paychecks" msprop:Generator_ParentPropName="tblJobInfoRow" msprop:Generator_RelationVarName="relationJobInfo_can_have_many_Paychecks" msprop:Generator_UserParentTable="tblJobInfo" />
      <msdata:Relationship name="Member_x0020_can_x0020_have_x0020_many_x0020_Paychecks" msdata:parent="tblMember" msdata:child="tblPaycheck" msdata:parentkey="PKmemberID" msdata:childkey="FKmemberID" msprop:Generator_UserChildTable="tblPaycheck" msprop:Generator_ChildPropName="GettblPaycheckRows" msprop:Generator_UserRelationName="Member can have many Paychecks" msprop:Generator_ParentPropName="tblMemberRow" msprop:Generator_RelationVarName="relationMember_can_have_many_Paychecks" msprop:Generator_UserParentTable="tblMember" />
      <msdata:Relationship name="Member_x0020_can_x0020_have_x0020_many_x0020_PhoneLU" msdata:parent="tblMember" msdata:child="tblPhoneLU" msdata:parentkey="PKmemberID" msdata:childkey="FKmemberID" msprop:Generator_UserChildTable="tblPhoneLU" msprop:Generator_ChildPropName="GettblPhoneLURows" msprop:Generator_UserRelationName="Member can have many PhoneLU" msprop:Generator_ParentPropName="tblMemberRow" msprop:Generator_RelationVarName="relationMember_can_have_many_PhoneLU" msprop:Generator_UserParentTable="tblMember" />
      <msdata:Relationship name="Expense_x0020_has_x0020_one_x0020_Receipt" msdata:parent="tblExpense" msdata:child="tblReceipt" msdata:parentkey="PKexpenseID" msdata:childkey="FKexpenseID" msprop:Generator_UserChildTable="tblReceipt" msprop:Generator_ChildPropName="GettblReceiptRows" msprop:Generator_UserRelationName="Expense has one Receipt" msprop:Generator_ParentPropName="tblExpenseRow" msprop:Generator_RelationVarName="relationExpense_has_one_Receipt" msprop:Generator_UserParentTable="tblExpense" />
      <msdata:Relationship name="Receipt_x0020_has_x0020_many_x0020_ReceiptItems" msdata:parent="tblReceiptItem" msdata:child="tblReceipt" msdata:parentkey="PkreceiptItemID" msdata:childkey="FKreceiptItemID" msprop:Generator_UserChildTable="tblReceipt" msprop:Generator_ChildPropName="GettblReceiptRows" msprop:Generator_UserRelationName="Receipt has many ReceiptItems" msprop:Generator_RelationVarName="relationReceipt_has_many_ReceiptItems" msprop:Generator_UserParentTable="tblReceiptItem" msprop:Generator_ParentPropName="tblReceiptItemRow" />
      <msdata:Relationship name="ReceiptItem_x0020_has_x0020_one_x0020_Brand" msdata:parent="tblBrandLU" msdata:child="tblReceiptItem" msdata:parentkey="PKbrandID" msdata:childkey="FKbrandID" msprop:Generator_UserChildTable="tblReceiptItem" msprop:Generator_ChildPropName="GettblReceiptItemRows" msprop:Generator_UserRelationName="ReceiptItem has one Brand" msprop:Generator_ParentPropName="tblBrandLURow" msprop:Generator_RelationVarName="relationReceiptItem_has_one_Brand" msprop:Generator_UserParentTable="tblBrandLU" />
      <msdata:Relationship name="ReceiptItem_x0020_has_x0020_one_x0020_ItemType" msdata:parent="tblItemTypeLU" msdata:child="tblReceiptItem" msdata:parentkey="PKitemTypeID" msdata:childkey="FKitemTypeID" msprop:Generator_UserChildTable="tblReceiptItem" msprop:Generator_ChildPropName="GettblReceiptItemRows" msprop:Generator_UserRelationName="ReceiptItem has one ItemType" msprop:Generator_ParentPropName="tblItemTypeLURow" msprop:Generator_RelationVarName="relationReceiptItem_has_one_ItemType" msprop:Generator_UserParentTable="tblItemTypeLU" />
      <msdata:Relationship name="ReceiptItem_x0020_has_x0020_one_x0020_Store" msdata:parent="tblStore" msdata:child="tblReceiptItem" msdata:parentkey="PKstoreID" msdata:childkey="FKstoreID" msprop:Generator_UserChildTable="tblReceiptItem" msprop:Generator_ChildPropName="GettblReceiptItemRows" msprop:Generator_UserRelationName="ReceiptItem has one Store" msprop:Generator_RelationVarName="relationReceiptItem_has_one_Store" msprop:Generator_UserParentTable="tblStore" msprop:Generator_ParentPropName="tblStoreRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>